Read many tables in a form 1

[Triger666]

Hello,

I have two tables with information on employees, each employee number only comes up once per table, I would like to be able, in a form, to be able to pull up all the info from both tables when I type in an employee number. Is this possible.

ex.
Table 1: empl:9999 win98
Table 2: empl:9999 Office Xp

I want to be able to pull up a form that has:

Form: empl:9999 win98 Office XP

 

[Rick39]

You could base your main form on Table 1 and create a subform in it based on Table 2

 

[Triger666]

How can you access the subforms in the form afterwords?