Display Information in subform based on main form selection


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,
 
Ad

Advertisements

G

Guest

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
 
Ad

Advertisements

G

Guest

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top