Filtering report using a form with combo boxes

[drjim]

Hi



I'm new to access. I've got a form [Performance Dynamic Report Builder] that has 3 combo boxes on it [specialty], [gender] and [grade]. I would like to be able to filter my report [Dynamic Specialty Performance] using up to 3 combo boxes. Sometimes only 1 box will be used so the other 2 will be blank, sometimes 2 will be used etc.

Thank

[June7]

For one method review http://datapigtechnologies.com/flash...tomfilter.html

[drjim]

Hi June7

Thanks for this but it's not exactly what I'm looking for. I need it for 3 combo boxes that may or may not be selected.

[orange]

There are free tutorials at Martin Green's site that may be helpful.
see http://www.fontstuff.com/access/acctut19.htm for some samples with code

[June7]

The technique should work with comoboxes as well. The key point is use of wildcard in the query parameters.