Checkbox in parameter

  • Thread starter Thread starter Hanksor
  • Start date Start date
H

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
 
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
 
Back
Top