Code to verify status of option button

S

Swish

Hi, anybody knows if there is such a code to verify is an option button is
selected??

Thank you in advance.
 
P

PC Datasheet

Is this what you are looking for --
If Me!NameOfOptionButton = True Then
<Option Button Is Selected>
End If


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
 
K

Keith W

Swish said:
Hi, anybody knows if there is such a code to verify is an option button is
selected??

Thank you in advance.
Click to expand...

An option button in an option group? Just test the option group for the
value assigned to the option button.

If Me.ogrMyOptionGroup = 1 Then

and so on.

HTH - Keith.
www.keithwilby.com
 
S

Swish

Hi PC,

The solution you posted can't work. The 1 Keith posted is the correct code.

Thank you for answering my question no matter what.
 
K

Keith W

Swish said:
Hi PC,

The solution you posted can't work. The 1 Keith posted is the correct
code.
Click to expand...

Thanks for the feedback Swish, glad I could help. Sadly, PC Datasheet posts
hurriedly prepared responses that are often wrong in order to advertise his
"services" for which he charges a fee. Most people on here are happy to
provide accurate responses for free.

Regards,
Keith.
www.keithwilby.com
 
P

PC Datasheet

Swish,

You didn't say your option button was in an option group. For future
reference, you can put a single option button on a form as a control. Look
at the toolbox. The way you wrote your question it sounded like this is what
you had. The option button then has two values; True when selected and False
when not selected. In this case the code I gave you would be what you need.

So dimwit 1 and dimwit 2 don't know what they are talking about!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
 
K

Keith W

So dimwit 1 and dimwit 2 don't know what they are talking about!!!
Click to expand...

Congratulations on another eloquent response. I am apparently a "dimwit"
and yet I managed to decode and answer the question correctly, it required
only a modicum of common sense which you clearly lack. Are there any panes
left in that glass house of yours?
 
Top