How to add an extra sheet in Form View

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

Guest

I'm setting up a database in Access 2002. There are several tables linked
together through One-to-Many relationships. The problem is displaying all the
information on Form View where I can only visualise one table at a time.
Consequently, I've tried to creat a sheet tab, as in Excel to allow for easy
navigation and data entry but my attempts have been unsuccessful.
Many thanks for your help.
 
You need to look into basing your form off a query instead of a table. That
way you can link the tables together in the query and use all the fields in
your form.

Hope this helps.
Jackie
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I add a new sheet to the original form view in Access 1
how to visualise all records on a form 7
Relationships, forms and command buttons 8
Adding extra interface with buttons to datasheet view of a form? 1
Can't create a report from my query in Access 1
Duplicating Foreign Key 7
Access 2010 - and Tabs 6
Updating subform on Tab Control page 0

Back
Top