Auto-unchecking check boxes...

  • Thread starter Thread starter DubboPete
  • Start date Start date
D

DubboPete

Hi all,

I need to change [un-check] the value of one check box, if another related
one is clicked instead...

The checkboxes (labels) are callled

drinkstopyn (YES)
drinkstopyn1 (NO)

The question that accompanies the checkboxes is:
"Do you wish to stop consuming alcohol?"

Now whilst the thought of that question is abhorrent to many on the group,
<insert smiley>, there is a professional reason for asking the question, and
I need the people on the end of the mouse to be allowed to dither, and
change their minds... "yes? no? hmm?.."

In order for them to do this, I need the alternative checkbox to become
unchecked when the drunken basta.. ermm, person clicks his other choice.
So If he/she clicks YES, and then changes his/her mind and clicks NO, then
YES needs to be unclicked.

There is a specific reason for two checkboxes, as I want further prompts to
appear (or disappear and be replaced with the other one) as they click the
checkbox... I just can't get the logic going in my mind, and that's
probably due to me being a drunken basta.... ermm, tired on Friday night!

TIA

DubboPete
ps, it's -1°C in Central West New South Wales Australia, and the 'real'
winter chill isn't due till JULY!
 
DubboPete,
I never would've guessed you're an Aussie... :-))

Now, to alternate those y/n boxes put code into the
AfterUpdate event of each box which sets the other box.

For drinkstopyn use something like -
***Air Code****

If Me!drinkstopyn = False Then
Me!drinkstopyn1 = True
Else
Me!drinkstopyn = False
End If

***Air Code****

Change the names around for drinkstopyn1

Air Code?? It's like Air Guitar with a bit less arm
waving... :-))
 
works fantastic Nick, thanks mate

DubboPete
ps, I understand <snip> ***AIR CODE*** </snip> and it's meaning! :-))

Nick Coe (UK) said:
DubboPete,
I never would've guessed you're an Aussie... :-))

Now, to alternate those y/n boxes put code into the
AfterUpdate event of each box which sets the other box.

For drinkstopyn use something like -
***Air Code****

If Me!drinkstopyn = False Then
Me!drinkstopyn1 = True
Else
Me!drinkstopyn = False
End If

***Air Code****

Change the names around for drinkstopyn1

Air Code?? It's like Air Guitar with a bit less arm
waving... :-))
--
Nick Coe (UK)
www.alphacos.co.uk

DubboPete said:
Hi all,

I need to change [un-check] the value of one check box, if another related
one is clicked instead...

The checkboxes (labels) are callled

drinkstopyn (YES)
drinkstopyn1 (NO)

The question that accompanies the checkboxes is:
"Do you wish to stop consuming alcohol?"

Now whilst the thought of that question is abhorrent to many on the group,
<insert smiley>, there is a professional reason for asking the question, and
I need the people on the end of the mouse to be allowed to dither, and
change their minds... "yes? no? hmm?.."

In order for them to do this, I need the alternative checkbox to become
unchecked when the drunken basta.. ermm, person clicks his other choice.
So If he/she clicks YES, and then changes his/her mind and clicks NO, then
YES needs to be unclicked.

There is a specific reason for two checkboxes, as I want further prompts to
appear (or disappear and be replaced with the other one) as they click the
checkbox... I just can't get the logic going in my mind, and that's
probably due to me being a drunken basta.... ermm, tired on Friday night!

TIA

DubboPete
ps, it's -1°C in Central West New South Wales Australia, and the 'real'
winter chill isn't due till JULY!
Click to expand...
Click to expand...
 
Back
Top