Tabs in Forms

[Guest]

I am trying to set up a form with different tabs. I want to know how to use
information from more than one table for each tab.

 

[Rick B]

Just pull the various tables to the query (your form should be based on a
query) and then put the desired fields on the desired tabs.

 

[Guest]

In your query, be careful not to include a primary key from the "one" side of
a one-to-many relationship. Instead include the corresponding foreign key
from the many side. This is one of the more common reasons that renders the
query "non-updateable", meaning you can't edit the recordset.

To test the query, execute it and try to change some data. If you can do
it, then you can use the query as a RecordSource for your form. Otherwise,
you'll have to alter the query to make it "updateable". Google
"non-updateable queries" for a more complete discussion of what reasons can
cause this problem.

Hope that helps.
Sprinks