Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from 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: ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book