Combo Box

[Judokid]

With the Combo Box, I have set it to choosing either "Yes" or "No". Is there
a way to program the combo box so that if "Yes" is selected, other checkboxes
appear with the choice of being checked off or not? Also, if "No" was
selected, is it possible to make the checkboxes disappear and it will
automatically deselect anything that was checked off?

My situation is this:

Combo Box [Yes/No]
Check Box [Email, Phone, Letter, In-Person]

If Yes is selected: Show Check Box [Email, Phone, Letter, In-Person]
If No is selected: Hide Check Box [Email, Phone, Letter, In-Person] &
unselect any checked boxes

 

[ruralguy via AccessMonster.com]

Do all of this in the AfterUpdate event of your ComboBox. Is the ComboBox
bound to a field? If so then you will want to put additional code in the
Current event of the form.

With the Combo Box, I have set it to choosing either "Yes" or "No". Is there
a way to program the combo box so that if "Yes" is selected, other checkboxes
appear with the choice of being checked off or not? Also, if "No" was
selected, is it possible to make the checkboxes disappear and it will
automatically deselect anything that was checked off?

My situation is this:

Combo Box [Yes/No]
Check Box [Email, Phone, Letter, In-Person]

If Yes is selected: Show Check Box [Email, Phone, Letter, In-Person]
If No is selected: Hide Check Box [Email, Phone, Letter, In-Person] &
unselect any checked boxes

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.


http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200904/1