Thanks for the information. In learning of course and
everyones input is great. Thanks again!
-----Original Message-----
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!
.
|