base results of a query on value i choose from a list box

[Muzzy]

I have created some simple databases before but have never faced this
challenge . I have no previous experience in sql and find it very complicated
to use.I have created a query that looks up the data i want for a certain
empoloyee by asking me the question Like [Who are you looking For] and the
query shows only the employee with all the data he has . Now i need to add a
listbox to choose the employee name and the query then opens with the data of
that employee .How can i do this ?

 

[Wayne-I-M]

Hi

Ctreate a form with your dropdown list.
Use the afterupdate event of the combo to open the query

Open the query in design view and in the ID column (criteria row) use the
build wizard to point to the combo box you have just created.

This will filter the query and then open it