Another Idea is a subform

Depending on the relationship between your two tables, you may also want to
try putting a subform on your main form. You do this when your main form has
on record per ID (Like a Purchase Order date, customer etc) and the subform
refers to a table with several records for that same ID (line items on a
Purchase Order). As you move to new records on the main form you will see
or input sets of records on the sub form.

The main form usually displays in form view and the subform in datasheet
view (but ohter options are possible)

There is a subform button on the form design toolbar and the wizard will
guide you through selecting the subform record source (table) and the links
required (parent-child)




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!