filter query

P

paula k

I have a form that is pulling information off of a query and is displayed in
the detail section. I cannot figure out (for the life of me) how to create a
drop-down at the top section (header) that filters to a specific record below.

My filter should look up "Project_Name", which is a part of the query on the
form. I do not want it to change the data, just perform a quick filter on
the data.

Any help??

Thanks!!
 
V

Van T. Dinh

This can be done easily using the ComboBox Wizard.

In the first Wizard Dialog, select the 3rd option "Find a record on my form
based on the value I selected in my combo box."

Afeter the Wizard creates the ComBoBox, have a look at the code created by
the Wizard.
 
Top