Microsoft Office® Access 2007 Inside Out

Working with the Tab Control

As you have just seen, a subform is an excellent way to create a form that lets you edit information from the one side of a relationship in the main form (contacts) while editing or viewing data from the many side of a relationship (contact events or contact products) in the subform window. Building a subform is very simple for a single one-to-many relationship. But what can you do when you have either multiple relationships or lots of data you need to deal with on a form and including all this information makes your form too large to fit on your screen? Access provides a tab control that lets you place multiple controls on individual tabs within a form. The controls on a tab can be as complex as subforms (in the case ...