Forms — your interface to multiple tables

Summary

With a grasp of the extensive armory of controls for Access forms, you can design and build forms for any purpose. Forms give users a helpful interface for entering data and for displaying it, either all records or a subset determined by an underlying query.

Try to think about a form from the users’ point of view; keep things simple but don’t hesitate to add helpful labels and captions. Use lines and rectangles to draw the eye towards groups of controls. Use the most appropriate control: a check box for a filling in a Yes/No field is quicker than selecting from a list. Use tab controls to give a logical flow to progress through the data entry process. Use list and combo boxes to control data entry and improve the integrity of your data.

The examples covered in this chapter all appear in chap18end.mdb.