Access 2003 Options Group
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
Software/Hardware used:
Software/Hardware used:
ASKED:
March 2, 2005 8:59 AM
UPDATED:
March 2, 2005 9:35 AM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
