Checkbox in parameter

[Hanksor]

Is it possible to use checkbox(s) in a parameter query form? I have created
custom form with combo boxes, but I have a need to be able to select
multiple items from a list. ie... I have division 1, division 2 and
division 3. I would like to be able to select division 1 and division 3 to
use in a select query by using a checkbox for the items. I hope this is
clear. Any help will be appreciated.

Thanx,

Hanksor

 

[Allen Browne]

If you can manage to refer to the check boxes in the Criteria of your query,
it will be very convoluted and inefficient.

An alternative is create a string dynamically, and set it as the Filter of
your form, or the WhereCondition of OpenReport. It would be simple and
efficient to build a filter string based on the checked boxes, or even a
multi-select list box.

For an example, see:
Use a multi-select list box to filter a report
at:
http://members.iinet.net.au/~allenbrowne/ser-50.html
Although the example shows OpenReport, the same string could be applied as
the Filter of the form, i.e.:
Me.Filter = strWhere
Me.FilterOn = True