option button value error

[zSplash]

I am trying to create a form to get input. I have a single optionGroup with
2 option buttons in it. There are 3 related textboxes. If opt1.value=true,
then tbx2 and tbx3 are not used; if opt2.value is true, then tbx1 is not
used. The trouble is, when I try to code that, I get an error (#2427 - "You
entered an expression that has no value."). What's up - why does
opt2.value=true generate the error? Here's my code:
If opt2.Value = True Then
tbx2.BackColor = "16777215"
tbx3.BackColor = "16777215"
tbx1.BackColor = "-2147483633"
Else
tbx2.BackColor = "-2147483633"
tbx3.BackColor = "-2147483633"
tbx1 = "16777215"
End If

TIA

 

[kingston via AccessMonster.com]

You're actually looking for the value of the optionGroup, not an individual
selection within the group.

If Me.optionGroup.Value = 1 Then
...
ElseIf Me.optionGroup.Value = 2 Then
...

 

[zSplash]

Thanks, Kingston. I don't have an optionGroup -- at least, when I type Me.
I don't get intellisense saying I have one (it does indicate I have opt1 and
opt2). I get an error ("method or data member not found") on .OptionGroup.

(But, I did put the two option buttons in a frame, and only one option
button is selectable at a time -- doesn't that imply an optionGroup??)

 

[kingston via AccessMonster.com]

Yes, it does. I don't know what the exact control name is. I just used
optionGroup because it was in your earlier post. Use the name of the frame
control. Just click once on the frame and see what it's called in the
toolbar or properties window.

Thanks, Kingston. I don't have an optionGroup -- at least, when I type Me.
I don't get intellisense saying I have one (it does indicate I have opt1 and
opt2). I get an error ("method or data member not found") on .OptionGroup.

(But, I did put the two option buttons in a frame, and only one option
button is selectable at a time -- doesn't that imply an optionGroup??)

You're actually looking for the value of the optionGroup, not an
individual

[quoted text clipped - 25 lines]

 

[zSplash]

Thanks, Kingston.

Yes, it does. I don't know what the exact control name is. I just used
optionGroup because it was in your earlier post. Use the name of the
frame
control. Just click once on the frame and see what it's called in the
toolbar or properties window.

Thanks, Kingston. I don't have an optionGroup -- at least, when I type
Me.
I don't get intellisense saying I have one (it does indicate I have opt1
and
opt2). I get an error ("method or data member not found") on
.OptionGroup.

(But, I did put the two option buttons in a frame, and only one option
button is selectable at a time -- doesn't that imply an optionGroup??)

You're actually looking for the value of the optionGroup, not an
individual

[quoted text clipped - 25 lines]

TIA

 

[zSplash]

Thanks, Kingston. Got it, thanks to your help!

Yes, it does. I don't know what the exact control name is. I just used
optionGroup because it was in your earlier post. Use the name of the
frame
control. Just click once on the frame and see what it's called in the
toolbar or properties window.

Thanks, Kingston. I don't have an optionGroup -- at least, when I type
Me.
I don't get intellisense saying I have one (it does indicate I have opt1
and
opt2). I get an error ("method or data member not found") on
.OptionGroup.

(But, I did put the two option buttons in a frame, and only one option
button is selectable at a time -- doesn't that imply an optionGroup??)

You're actually looking for the value of the optionGroup, not an
individual

[quoted text clipped - 25 lines]

TIA