Creating a search box in Access 2010 form

[d4jones]

I would like to create a search box on a form where the user types in the unit # and press enter, and the unit information comes up. the form is based on a table, the unit column is a txt field which is unique and the primary key in the table.

Thank you, in advance for your assistance.

[pbaldy]

Presuming the form is bound to the table, the simplest solution is the combo box wizard, choosing the third option, "Find a record...".

[d4jones]

it worked this time, i had been trying that and wasn't the results. So thank you.

[pbaldy]

No problem; maybe I'm just a good-luck charm.