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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can a Check Box Prevent Other Fields from Being Used? 1
Create Check box that controls visibility of a text box or combo b 1
how to create checkbox to check the ones that we want to select 3
MS Access problem 0
Run a form in background using checkboxes on main form 0
Check box issues 2
how to cause checked yes/no items to appear in a list in another part of the form... 8
database does not work 3

Back
Top