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" wrote in
message ...
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!