Using tickbox/dropdown on form to customise query

[Rik_StHelens]

Hi everyone,

I have set up a email contacts database for creating email lists. It contains both fleet and tyre dealer customers.

I have created a form which (will) allow users to customise the query to give them the appropriate list of contacts. The form has a series of dropdown and tick boxes to allow users to select options.

For example, a user can create a list of all "Dealers" (dropdown) "accountants" (dropdown) who are dedicated on "breakdown network 1" (tickbox).

How can I use the tickbox so that:

If checked it gives me all dealers on network 1
If unchecked it gives me everything, rather than only dealers who are NOT on that network.

I was going to try IIF(Forms!MyForm!MyCombo=Yes,"Yes","No") but this doesn't provide the flexibility users need to create custom lists.

Thanks for your time/help

 

[Galaxiom]

Best done with a dynamic query built in VBA. Basically the code uses If Then Else sections to construct the text of the sql statement based on the form settings.

 

[Rik_StHelens]

Is there a good example anywhere that you would recommend?

& if not, is there another way around this for someone who has never written VBA

Thanks