Use Multiple Tables on Tab Form

  • Thread starter Thread starter Tim Leach
  • Start date Start date
T

Tim Leach

I am using a tab form and on one of the pages I need to use a repeatable
page for additional contacts which are in a seperate table. When I first
use the query to bring up a blank record, using both tables it lists all
records in both tables. If I take the query part referencing the second
table out I get ?NAME errors on the additional contacts page. Any help you
can offer on this would be greatly appreciated. Thanks Tim
 
Tim

If you take out the part referencing the second table, not all data is
returned that the form needs? Why are you removing the reference to the
second table?
 
I am using a tab form and on one of the pages I need to use a repeatable
page for additional contacts which are in a seperate table. When I first
use the query to bring up a blank record, using both tables it lists all
records in both tables. If I take the query part referencing the second
table out I get ?NAME errors on the additional contacts page. Any help you
can offer on this would be greatly appreciated. Thanks Tim
Click to expand...

I would suggest displaying the data from the second table in a
Subform. Base the mainform on the main table, and the subform on the
"additional contacts" table, rather than trying to create a query
referencing both tables.
 
On Fri, 14 May 2004 05:31:53 -0700, Jeff Boyce wrote:

I don't want to see all the records. It should be a blank record so I can
enter the data into the form for staorage in the table.
 
I would suggest displaying the data from the second table in a
Subform. Base the mainform on the main table, and the subform on the
"additional contacts" table, rather than trying to create a query
referencing both tables.
Click to expand...

I will try that as soon as I figure out what the subforms are. Thank You
 
Back
Top