Find a record by selecting a value from a list

On a form, you can create a list box or a combo box that finds a record when you select a value from the list.

1. Open the form in Design view.
   
   
2. Click Control Wizards in the toolbox if it's not already pressed in.
   
   
3. In the toolbox, click List Box or click Combo Box .
   
   
4. On the form, click where you want to place the list box or combo box.
   
   
5. In the first wizard dialog box, click the option to find a record based on the value you selected in the list box or combo box.
   
   
6. Follow the directions in the wizard dialog boxes. In the last dialog box, click Finish to display the list box or combo box in Design view.

If you want to see the event procedure that makes the list box or combo box work, open the box's property sheet, and then click the Build button next to the AfterUpdate property box.