Optional ComboBox Filtering

[luke jones]

Hey guys, have 2 issues I can't seem to find the answer to.

1. Age Ranges

2. As with the same form described in question 1, there is a secondary query which counts records based on a selection from 8 combo boxes, currently you must select a choice from every combo box to obtain any records, I need to be able to leave some combo boxes blank and still run the query. I hope this makes sense.

Thanks in advance for any help.

[NeoPa]

Show us how you're doing your filtering at the moment Luke and we can consider an alternative that is on broadly similar lines. There are various ways of doing this depending on your circumstances.

Welcome to Bytes!