Hi guys i am new to the forum and am hoping for some help because this has been doing my head in for a few days now.
I am a noob at access and i hope you will be patient with me
I am using Access 2007. I have a form called Student that has student details and a seperate form called Parent 1 which has parent details. What I want is a button on the Student form that will open the Parent 1 form with the detials related to the student i was just viewing.
The student and parent are linked by the same ID (The Student ID is the Primary key)
I have managed to create a button using the wizard that opens the Parent 1 form however it doesn't link to the related parent.
In the wizard i chose Open the form and find specific data to display and linked the ID fields.
Do i need to create a query? If so what is the criteria?
Or do i need to use a Macro or VB Code? (i am really new at these and would need some guidance if i need to use this)
Any help would be fantastic as for the first time google has been of little help to me!
Cheers
Miranda
PS if needed i can attach the database
I am a noob at access and i hope you will be patient with me
I am using Access 2007. I have a form called Student that has student details and a seperate form called Parent 1 which has parent details. What I want is a button on the Student form that will open the Parent 1 form with the detials related to the student i was just viewing.
The student and parent are linked by the same ID (The Student ID is the Primary key)
I have managed to create a button using the wizard that opens the Parent 1 form however it doesn't link to the related parent.
In the wizard i chose Open the form and find specific data to display and linked the ID fields.
Do i need to create a query? If so what is the criteria?
Or do i need to use a Macro or VB Code? (i am really new at these and would need some guidance if i need to use this)
Any help would be fantastic as for the first time google has been of little help to me!
Cheers
Miranda
PS if needed i can attach the database