SETTING UP A FIELD'S LOOKUP PROPERTIES FOR USE ON FORMS
Before Access 95, when you wanted a lookup on a field such as a combo box, you had to create it at least once and then copy it from one form to another. Now, Access allows you to create the lookup at the table level and have it propagate when you use the field on the various forms, using any type of lookup control that you specify.
Access gives you three types of controls to choose from: TextBox (the default), ListBox, and ComboBox. Figure 10.1 shows an example of a lookup control combo box for the Rating field in the MovieTitles table, which is on the CD-ROM in the chap10.mdb database in the \Examples\Chap10 folder.
Figure 10.1. Setting lookup fields at the table level can save time later ...
Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
