create a form with multiple tables

R

RocketRen

im using access 2003, and im triing to create a form with multiple tables. i
have tried to use a query to put all these tables into, but when the field
are put on the form, and i switch over from design view to form view there is
nothing there. i click on filter form and i can now see that i added to the
form.
 
R

Rick B

Typically, you would have to include multiple tables as subforms on the
form. What type of relationship exists between the tables? Unless it is
one-to-one, you will need to use subforms for the "many" tables in a
one-to-many relationship.
 
J

John Vinson

im using access 2003, and im triing to create a form with multiple tables. i
have tried to use a query to put all these tables into, but when the field
are put on the form, and i switch over from design view to form view there is
nothing there. i click on filter form and i can now see that i added to the
form.
Click to expand...

You'll get the blank form if two conditions are true:

1. The Form's Recordsource doesn't contain any records (no existing
records exist to view)
2. The Recordsource isn't updateable (no new record either)

Trying to create One Grand Master Query is not generally a good idea.
If ANY table has no matching records (assuming you're using the
default Inner Join) you'll get no data; and any more than three or so
tables will probably give a non-updateable recordset.

Follow Rick's good advice and Don't Do It This Way. Instead, use Forms
for the "one" side tables, with Subforms for the "many".

John W. Vinson[MVP]
 
Top