O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required