Update a Form based on clicking on a record in a subform

[gal4y]

I have a Form that has information about instructors (SSN, Last name, first name and so on) [This is based on query]. Within the form, I have a subform that is based on a query that has last name, first name and phone number.

I want the ability to click on a record on the subform and then for the form to update to that record.

I have tried the following code with no luck.

Private Sub Field61_Click()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[Instructor_SSN] = '" & Me![Field61] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

Thanks for any help in advance

Greg

 

[zevw]

I think you should create a combo box in the form header and query the Tables where you have the Instructor info. and after you have selected the info it should update your form. For a good sample go to Northwind.mdb in the samples directory which comes with every installation of Microsoft access and you will see many forms that do exactly this. look at the properties and event procedures of the form and you will see how to do it.

To find the Nortwind.mdb make a find or search for that name in all of drive C: and you should find it.