Check boxes

A

an

Hi!

I have in main form two check boxes.
OI would like when

If Checkbox1 = Yes Then
Checkbox2 = No
else
Checkbox2 = Yes Then
Checkbox1 = No
end if

Thanks in advance.
an
 
L

Larry Daugherty

You can easily do that but the effect is the same as if you have a
single checkbox and simply check whether it's checked....

To do what you've asked, In the AfterUpdate event of a checkbox place
the code:

if me.mycheckbox=true then
me.myOthercheckbox=Fales
endif

HTH
 
R

Ron2006

If you go with the second approach, you will also need the opposing
code in the myothercheckbox after update.


It could also be written

for mycheckbox afterupdate event

me.myothercheckbox = not me.mycheckbox


and for myothercheckbox afterupdate event

me.mycheckbox = not me.myothercheckbox
 
A

an

LD,

Thank you very much.
an

Larry Daugherty said:
You can easily do that but the effect is the same as if you have a
single checkbox and simply check whether it's checked....

To do what you've asked, In the AfterUpdate event of a checkbox place
the code:

if me.mycheckbox=true then
me.myOthercheckbox=Fales
endif

HTH
Click to expand...
 
L

Lance

It should be in your toolbar. It's a box with "xyz" across the top. Just
draw it on your form and let the wizard walk you the rest of the way through.
It's really all you need for this.
 
L

Lance

No idea about 2007, haven't had to use it yet. But I'd imagine it's there
someplace, you might need to physically add it to your toolbar or something.
 
A

an

I will try.

Thank you, L
an


Lance said:
No idea about 2007, haven't had to use it yet. But I'd imagine it's there
someplace, you might need to physically add it to your toolbar or something.
Click to expand...
 
A

an

Ok, L.

Located.
Thank you very much.
an


Lance said:
No idea about 2007, haven't had to use it yet. But I'd imagine it's there
someplace, you might need to physically add it to your toolbar or something.
Click to expand...
 
A

an

Ok, L.

Located.
Thank you very much.
an

Lance said:
No idea about 2007, haven't had to use it yet. But I'd imagine it's there
someplace, you might need to physically add it to your toolbar or something.
Click to expand...
 
Top