Access 2000: how to create check box so that...

P

philippe

So, creating a check box using the result of a query listing a few choices.
Then, using the fields checked to run another query. Tried checkbox, but does
not work
 
M

Michel Walsh

Use a combo box.

The problem with check boxes is that if you have 6 results, you need (room
for) 6 checkboxes, while if you have 60 results, you now need (room for) 60
checkboxes! A combo box is more versatile, since it accommodate both cases
as easily.

The second query can read the combo box value (FORMS!FormName!ComboBoxName)
and takes action based on its value (or NULL, if there is no value).


Hoping it may help,
Vanderghast, Access MVP
 
Top