Displaying Values in Other Controls

You may want to use a combo or list box to let the user pick some record, and then update the contents of other form controls with corresponding values from that record. This section discusses the following ways to achieve this behavior without macros or Microsoft Access Basic code (for examples of using code to work with combo boxes, see "Application Design Techniques" later in this document):

• Use AutoLookup.

• Use a calculated field with the DLookup function.

• Use a subform linked to the combo or list box.