Complicated Filtering Query

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

Guest

I realized I was posting on the wrong message board, so I thought I would
post it here. Here's my question:


Now I have another question. When select from two different combo boxes, I
want it to only be narrowed down to those two selected. For example if I
choose a name like Dan and then a project status like Open, I get all of
Dan's open projects and also everyone else's open projects, when I really
just wanted Dan's. Is there any way to do this?????
 
Build a query and use the ComboBox for criteria. Like --
[Forms]![YourForm]![ComboBox1]
and
[Forms]![YourForm]![ComboBox1]

Put both on the same criteria row so they will AND. Use the query for the
forms record source.
 
Back
Top