Controls with different sources

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Sounds like you are talkiing about a bound form.
you will have to unbind the form and populate the form
with code.
 
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
 
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)
 
Thanks for the information. In learning of course and
everyones input is great. Thanks again!
 
Back
Top