Results from combobox on form do not show up on designated table when adding a new record

[ensmith1]

I have a form using two tables one contains all the employee names, etc (table 1). The second table contains the responses when a recorded is added. The problem i am having is when i select add record on the form it does not include the names from table 1 only the responses are captured on table 2.

[RuralGuy]

Is the recordsource of your form a query with the two tables joined?

[ensmith1]

No the recordsource is table 2 where the added results are.

[RuralGuy]

A Form can *only* use one recordsource. The results you are getting are as I would expect. A query joining two tables with the proper keys will let you treat both tables as if they were one.

[ensmith1]

Thanks for the help. One more question - how can i link a list box to a form category i.e. Employee ID so that when that Employee ID is shown on the form the list box shows all the history of that ID on the form from a query?

[RuralGuy]

That really depends on how you have your tables structured. What you described is similar to how you use SubForms and the SubFormControl has a built in function (LinkMaster/ChildFields) that can do all of the work for you.

[ensmith1]

Ok i will try the Subform. Thanks again.

[RuralGuy]

Post back here if you need additional assistance.