Linking text boxes on main form to records in subform?

[NewShoes]

Hey all,

A bit of an odd one but I would like a few text boxes to be populated on the main form when a record in the subform is clicked. So, on the subform, if I click into record number 3 I would like the text boxes on the main form to display employee name, age or whatever else is stored in the record source of the subform.

Is this possible, and if so, how?

Many thanks for any help!
-NS

 

[John Big Booty]

You could use the DLookup() function to populate the text box (on your main form) based on the current record on your sub-form.

Given that you are dealing with forms and sub-forms check this link to get the correct syntax for referring to the record on the sub-form.