Complicated Filtering Query

A

Angela

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?????
 
K

KARL DEWEY

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.
 
Top