To search a record with specific …

Search for a specific record

Open the table or form, and then click the field that you want to search.

On the Home tab, in the Find group, click Find, or press CTRL+F. ...

In the Find What box, type the value for which you want to search.

Right-click the form in the Navigation Pane, and then click Design View.

On the Design tab, in the Controls group, ensure that Use Control Wizards Button image is selected.

In the Controls group, click List Box or Combo Box.

On the form, click where you want to put the list box or combo box.

On the first page of the wizard, click Find a record on my form based on the value I selected in my combo box/list box, and then click Next.

The Find a record... option is not available.

If the option Find a record on my form based on the value I selected in my combo box/list box is not displayed, it is likely because the form is not bound to a table or a saved query. The form must be bound to an object that is available in the Navigation Pane under Tables or Queries.