Need to have a find box

[Laurie Edge]

I've done it before and I don't remember how. I need to
create a field in a form that is just a dropdown field
with all the names in it so that I can go to a name in
the field and the name will be found within the database.
Help

 

[tina]

is your form bound to a table (or query)? and you want to use the combo box
to find a record in the open form? if yes to both, the easiest way to build
the combox box (and code) is to use the Controls Wizard.
in the form's design view, make sure the Controls Wizard button on the
toolbar is selected - pushed in. click on the combo box button, then click
on your form where you want the box to be. the Wizard dialog will open; the
3rd choice should say something like "i want to find find a record in my
form". select that choice, then continue thru the wizard, following the
prompts.

hth