Access 2003 Options Group

0 pts.
Tags:
Microsoft Access
Most of my work is with VB and I always use option buttons within a frame. I'm trying to do the same thing in Access 2003 and I get an error message: You entered an expression that has no value. For simplicity this is what I'm doing: If Me.Option3.Value = 1 Then Msg = "A" ElseIf Me.Option5.Value = 2 Then Msg = "B" ElseIf Me.Option7.Value = 3 Then Msg = "C" End If Any thoughts? Thanks Tony
ASKED: March 2, 2005  8:59 AM
UPDATED: March 2, 2005  9:35 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I can’t tell for sure in your question and I think you are, but you need to use an Option Group and not a Frame. Then the control that is the Option Group has the value and the individual option controls, usually Option Buttons do not have a value property. So if your Option Group control is named MyOptionGroup and within it you have MyOption2, MyOption4, etc, you would get the value by using Me.MyOptionGroup.Value. If you are using Me.MyOption2.Value you should get “Object doesn’t support this property or method.” You can however get the OptionValue of the individual Option Buttons by using Me.MyOption2.OptionValue. Hope I didn’t misunderstand the question too badly.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following