Search from my input

[Steven]

I'd like to be able to type in and/or use a pulldown menu
in a form to enter a Project number which would then
display all the related information concerning that
project. How can i do this?
Is it also possible to do such a search with a keyword.
thanks for any help

 

[John Nurick]

Hi Steven,

In Form Design view, make sure that the magic wand button on the control
toolbox is depressed. Then put a new combobox on your form (often it's
best to select Form Header/Footer from the View menu and put the
combobox in the form's header area). The combobo wizard will appear;
select "Find a record on my form based on the value I selected in my
combobox" and follow the instructions.