Display info from parent form in child form

[Leonidsg]

Hello,



I think this is relatively simple. What I am trying to do is in my Form (source is a child table) when I type in medical record number two combo boxes which would be linked to parent table display the patients first and last name. I figure I need two combo boxes, one linked to the first name field of the parent table and one linked to the last name field of the parent table. Then I would also need some Afterupdate command for the Medical Record Number text box whose source is the child table. That being said how do I actually write to code and what is the best way to link the two combo boxes to the parent table.

Thank you,
Lenny

[June7]

Why would you use comboboxes instead of textboxes for patient name parts? Why do the names need to display in the subform if they are viewable just above on the main form? Aren't the forms synchronized by PatientID?

[Leonidsg]

This is a different form then you helped me with. You are correct I should use textboxes. The only reason I wanted to do this is so I didn't need to structure a Form, Subform, Subsubform. I would for some forms prefer that the main form be the child form and just pull in the name so when the patientID is put in we can have a confirmation that it is the same named patient.

Thank you,
Lenny

Why would you use comboboxes instead of textboxes for patient name parts? Why do the names need to display in the subform if they are viewable just above on the main form? Aren't the forms synchronized by PatientID?

[June7]

Options:

1. include the employees table in the form RecordSource query, join type "Include all records from {the primary data} and only those from Employees that match", bind textboxes to the name fields, set properties Locked Yes, TabStop No

2. textboxes reference columns of combobox that has the name fields

3. DLookup expressions in textbox