A form has one record source but that record source can be a query which
links different tables together on a common field

You probably need to create a query and use that as a record source



wrote in message
...
For imputing data on a single form I want to combine two
tables but the forms control source is only showing one.
How does one show different control sources? Thanks!