Linking Form & Sub Form

[Guest]

I work for a staffing firm and created a form for tracking employee
information. The form has the personal info and school history at the top
which is in an INFO TABLE. I have a subform at the bottom of this form for
their emploment history so I can use the navigatin button to scroll to each
job listed so all information can viewed all on one page. This subform info
is on a EMPLOYMENT TABLE. I have the tables linked by the employee's SSN
that I entered manually on both tables. I want to be able use this form to
enter new employees we will receive. Is there a way that once I enter the
SSN in the employee information(INFO TABLE) section at the top of the form,
that the same SSN will go on the EMPLOYMENT TABLE used in the subform so that
I can tab down and enter the employment history without having to manually
enter the SSN in the subform as well so they will link? Hope this made
sense.

 

[Nikos Yannacopoulos]

Supe,

You need to link the two forms (main and sub) properly. To do it, open
the form in design view, select the subform object, display the
properties window for it, go to tab Data and select the SSN field for
the main and subform in the Link Master Fields and Link Child Fields
drop-down lists respectively.
Note: in the subform, you can set the Visible property of the SSN
control to No; it will work fine as long as it's there, you don't need
to display it.

HTH,
Nikos