I am trying to create an option box/toggle box in a form that will allow me to choose more than one option. FOr example, the question on the form is "Please check all that apply." How do I make a box that allows someone to check more than one option? Any suggestions would be greatly appreciated!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Toggle Buttons/Option Boxes 1
- Thread starter Crogirl
- Start date
-
1
- #2
- Thread starter
- #3
I'm not sure what you mean by "query from teh check boxes".
You can use the state of the check boxes as criteria in a query.
For example, in a query design view, in a yes/no field, you could enter
Forms![frmFormName]![chkCheckBoxName]
If the box is checked, your results will include the records that have True/Yes/-1 in that field. If the box is not checked, you will get the records that have False/No/0 in the field.
Check boxes can also be set to have 3 states by setting the Triple State property to Yes on the Data tab of the properties window. It's been a long time since I've used this feature and I'm drawing a blank on an example of when you might want to use it.
Also, I must clarify what I said before. Multiple check boxes can be selected unless they are in a frame. Only one option in a frame may be selected.
If you want a group of check boxes to appear to be in a group on a form while allowing selection of multiple options, add the check boxes individually and line them up how you want them. Then use the rectangle object to draw a box around them. _________
Rott Paws
...It's not a bug. It's an undocumented feature!!!
You can use the state of the check boxes as criteria in a query.
For example, in a query design view, in a yes/no field, you could enter
Forms![frmFormName]![chkCheckBoxName]
If the box is checked, your results will include the records that have True/Yes/-1 in that field. If the box is not checked, you will get the records that have False/No/0 in the field.
Check boxes can also be set to have 3 states by setting the Triple State property to Yes on the Data tab of the properties window. It's been a long time since I've used this feature and I'm drawing a blank on an example of when you might want to use it.
Also, I must clarify what I said before. Multiple check boxes can be selected unless they are in a frame. Only one option in a frame may be selected.
If you want a group of check boxes to appear to be in a group on a form while allowing selection of multiple options, add the check boxes individually and line them up how you want them. Then use the rectangle object to draw a box around them. _________
Rott Paws
...It's not a bug. It's an undocumented feature!!!
- Status
Similar threads
- Locked
- Question
- Locked
- Question