How to Find a Record in a Listbox
- 1). Open your Microsoft Access database.
- 2). Right-click the form that you designed in the navigation pane and choose "Design View."
- 3). Click the "Design" tab. Navigate to the "Controls" group. Check "Use Control Wizards" if it is not selected already.
- 4). Click "List Box" under the "Controls" group from the last step.
- 5). Click the area on the form where you want to put the list box. This will start a new wizard.
- 6). Click "Find a record on my form based on the value I selected in my combo box/list box" when the wizard starts. Click "Next" to proceed.
- 7). Click the value associated with the record you are looking for. Follow on-screen prompts to find the record.
- 8). Click "Finish" when prompted.
Source...