Toggling Checkboxes

[smart_aleck72]

I am trying to set up a pair of checkboxes where only one may be
checked at a time BUT both should be able to unchecked as well. Thus
an option group does not work as at least one value will always be
true.

I tried:

Private Sub chkRMA_Click()
chkRMAOther = False
End Sub

Private Sub chkRMAOther_Click()
chkRMA = False
End Sub

I found that when I set the opposite checkbox value, I call its event
as well, thereby setting both to false.

Any suggestions?

[Fred Zuckerman]

<sm***********@yahoo.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

I am trying to set up a pair of checkboxes where only one may be
checked at a time BUT both should be able to unchecked as well. Thus
an option group does not work as at least one value will always be
true.

I tried:

Private Sub chkRMA_Click()
chkRMAOther = False
End Sub

Private Sub chkRMAOther_Click()
chkRMA = False
End Sub

I found that when I set the opposite checkbox value, I call its event
as well, thereby setting both to false.

Any suggestions?

I'm pretty sure that changing the setting of another control does NOT fire
that control's event. Yet I see a flaw in your logic. Remember that the
control is checked when you click it, but then it becomes unchecked when you
click it again. So if you click it a 2nd time it will become unchecked and
the other control will become unchecked, too.

Instead, try using the AfterUpdate event. Such as (air code):

Private Sub chkRMA_AfterUpdate()
If Me.chkRMA = True
Me.chkRMAOther = False
Endif
End Sub

Private Sub chkRMAOther_AfterUpdate()
If Me.chkRMAOther = True
Me.chkRMA = False
Endif
End Sub

Fred Zuckerman

[PC Datasheet]

Private Sub chkRMA_Click()
If chkRMA = True Then
chkRMAOther = False
End If
End Sub

Private Sub chkRMAOther_Click()
If chkRMAOther = True Then
chkRMA = False
End If
End Sub

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

<sm***********@yahoo.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

I am trying to set up a pair of checkboxes where only one may be
checked at a time BUT both should be able to unchecked as well. Thus
an option group does not work as at least one value will always be
true.

I tried:

Private Sub chkRMA_Click()
chkRMAOther = False
End Sub

Private Sub chkRMAOther_Click()
chkRMA = False
End Sub

I found that when I set the opposite checkbox value, I call its event
as well, thereby setting both to false.

Any suggestions?

[rkc]

sm***********@yahoo.com wrote:

I am trying to set up a pair of checkboxes where only one may be
checked at a time BUT both should be able to unchecked as well. Thus
an option group does not work as at least one value will always be
true.

I tried:

Private Sub chkRMA_Click()
chkRMAOther = False
End Sub

Private Sub chkRMAOther_Click()
chkRMA = False
End Sub

I found that when I set the opposite checkbox value, I call its event
as well, thereby setting both to false.

Really? I can't make that happen. What you have works fine for me.
What aren't you telling us?

[Jamey]

if you set it up as an option group, you could leave the default value
for the group unset and skip all the setting and unsetting via if
functions. that may not work for you since once checked, some value
will always be set for the option group. you could unset the option
group programatically however by simply erasing the Value property
associated with it.

[mathilda]

I stepped through it in debug mode and when I changed the value on the
other check box it took me to it's click event. Surprised me, too.
Running Visual Studio 6.0 in WIN 2000.

[rkc]

mathilda wrote:

I stepped through it in debug mode and when I changed the value on the
other check box it took me to it's click event. Surprised me, too.
Running Visual Studio 6.0 in WIN 2000.

O.K. So your using VB6 not Access for frontend development.
The Access checkboxes don't act like what you described.

Did you come up with a solution to this yet?