second Option group not recognized

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Molasses26 - 30 Apr 2008 21:33 GMT

I created a form with one option group on it and later added a second option
group but when I try to reference the options in the second group in VB code
it doesn't "see" them.
Basically my form consists of a text box called KW
One option group called Metering with 4 choices
Option11 = 1
Option13 = 2
Option15 = 3
Option17 = 4
One option group called Service with 4 choices:
Option22 = 5
Option24 = 6
Option26 = 7
On my KW field I want to write an AfterUpdate code that disables the
Option26 in the Service group if the value of KW is less than 20.
IF me.kw < 20 then
me.option26.enable = false
else
me.options6.enable = true
end if

When I am typing the code and I type me. I see the options from the first
group on the list but not the options from the second group. What is my
malfunction here?

Thanks!

Reply to this Message

strive4peace - 01 May 2008 07:12 GMT

modify the value of the FRAME

'set option26
me.service_controlname = 7

btw, you really should give your controls meaningful names. Access, of
course, has no idea what to call them, so it just names them like this:
option26. I would do something like Service_something

where
'something' describes the option

OR, what I actually do is this:
Service_03
if it is the 3rd choice in a frame called Service ... but then I have
code that loops through the option choices and boldfaces the label of
the selected option so there is a logical REASON to use numbers in the
name <smile>

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*

> I created a form with one option group on it and later added a second option
> group but when I try to reference the options in the second group in VB code
[quoted text clipped - 22 lines]
>
> Thanks!

Reply to this Message