How To Use Tabs To Show Lots Of Related Data On One Form In Access

It is rarely the case that an access database will contain lots of unrelated data. When designing a form to enter a customer, a simple customer form would do the job well enough. A user could enter the name and contact details on one page. There may be drop down boxes linked to other related tables such as the account manager. This would be a simple use of related data on a form. Usually more complicated forms are required since when a user looks up a customer, they may well want to see all the related orders on the same form rather than having to look them up in a separate place. One method of achieving this is through the use of tabs containing sub forms.

The full article appears here:
http://www.microsofttraining.net/article-1167-how-use-tabs-show-lots-related-data-on-one-form-in-access.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com