filter query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dissapearing Details Section very strange 11
filtering a form based on a filter on an open form 2
Using DSUM to get running total on a filtered form 0
Triple Split Window 0
Adding a lookup list to further filter form results 1
2007 Forms - Quick Filters not working 5
filtering query 3
Subform doesn't appear if filter applied to main form 11

Back
Top