View Single Post
  #5  
Old August 31st, 2004, 04:01 AM
external usenet poster
 
Posts: n/a
Default

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!



.