Access 2002 Programming by Example

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