Form with multiple combo boxes results

[nancybrown]

I need to create a form to show contribution history. The form will have three different combo boxes: 1) type; 2) contributor; 3) benefactor.

I would like the user to be able to pick one choice from either one, two, or three combo boxes. Example: the user can select an item from the type cbo only OR, one from the contributor cbo, OR one choice from the type, one from contributor, and one from benefactor they can. How do I structure the query or queries to return results?

Thanks in advance.

 

[Micron]

You can do this with paramatized queries, but there is a better way. Look here and get the lowdown on the options and why one way is favoured over the other.
Microsoft Access tips: Search criteria