Populate info

[Pam Coleman]

I have a main form created frm a master emp quey, which populates employee
info when I enter an emp #. My subform contains the fields for data entry
users which is created from a badge table. Question, I have an emp field in
the subform, is there an easy way that when a user types the empl# in the
main form, that it will also fill in the subform? I want an emp# in both
the main and subform.

Thanks,

 

[M Skabialka]

Highlight the subform, and under Properties:
Link Child Fields: empl#
Link Master Fields: empl#

That way the subform will only display records where empl# is the same as
the main form.

Mich