Easy Filter

[jereece]

I have a form frmIssues. This form is based on a Query qryIssues which is based on tblIssues. On the form, I would like to provide a means to filter what the form displays. The fields I would like to filter on incude cmbSite, cmbGroup, cmbStatus and cmbConsultant. These are all combo boxes. I would like to be able to filter the form so that the user can show only the records for the Site, Group, Status and Consultant. So for example, if I am looking for the records I entered at Site 1, Group A, Status Active, and my name as the consultant, applying these filters would narrow the form results so that I can find my record easily.

Any suggestions on how best to do this?

Thanks,
Jim

 

[CEH]

search on cascading combos... Or take a look at this on... "combo.zip" I think this is what your looking for...
http://www.access-programmers.co.uk/forums/showthread.php?t=117112

 

[jereece]

search on cascading combos... Or take a look at this on... "combo.zip" I think this is what your looking for...
http://www.access-programmers.co.uk/forums/showthread.php?t=117112

That's kind of what I am looking for. One thing I don't like is that it appears you use a subform that looks like a table. I don't have a lot of experience with subforms, but can it look like the original form?

Also, once you filter on a particular sequence, how do you get back to an unfiltered state?

Thanks,
Jim