Display Information in subform based on main form selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables:
1- Employee (EmployeeID PK)
2- Operations (EmployeeID Fk)

I have one main form with a combo box for employeeID from table employee; I
created a subform for the operations. What I need when a user selects an
employeeID on the main form the subform should show the operations details
for that employee. I have set the Link Master/Child Fields to “EmployeeIDâ€,
when I first run the main form I get prompt box asking for EmployeeID. Once
that ID entered I could see the subform listing operations related to this
employee, but if I attempt to enter a new ID the Subform doesn’t show the new
results?



Regards,
 
Hi

You need to place the EmployeeID (EmployeeID PK) on both forms. After you
have done this you can open the properties box (Data) and you will have a
list of suitable fields to link. Select Employee (EmployeeID PK) on both
forms.

Hope this helps
 
Hi Wayne, (Man-U or Man-City)

Thanks for your help,

I have the employeeID on the main form and on the subform and I also have
them linked using the EmployeeID field. How do I get the subform to refresh
each time a new ID entered? Most of the posting I have reviewed mentioned the
Linking of Master/child field which I have done, but the subform still
doesn’t refresh?

Regards,
 
Back
Top