O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

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

Lookup List

A common database convention is lookups. You might want to look up a customer address, or you might not remember the product code for an inventory item. Therefore, you need to see a list of products. You also might want to see the item itself, along with its code. Lookups can fill other controls with synchronized data.

Let’s take a look at a few techniques that use controls for table lookups. The first method uses a query to look up data. The second method uses calculated fields to obtain the lookup data. The third method combines lookups and calculations. The first two methods have a control source in the Lookup field. This ensures that the data remains when the form closes.

The next steps take you through the various techniques: ...

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