• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. EXPANDING THE POWER OF YOUR ... > SETTING UP A FIELD'S LOOKUP PROPERTI...

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint