Searching Forms for Data

[Guest]

I am creating a database for our company to use. I have a table and form
created to enter data that is then stored in the table. I would like to
create a main menu form that has the ability to act like a search for records
in the table and then display all results that meet the applicable field
criteria in the data entry form view. Essentially, I want to open the main
menu form and select that I want to see all records entered by John Smith.
By selecting his name and then execute, the data entry form would come up
with say the 10 records that were entered in the form by John Smith and then
stored in the data table. One of the fields in the table and form is
Initiator. I am ussing Access 2003 in a Windows XP operating system.

 

[pietlinden]

You should be able to use the combobox wizard to do this. Select the
"show records matching this value" or whatever. Just plonk it in as an
unbound control, and you're off to the races