second Option group not recognized

M

Molasses26

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!
 
S

strive4peace

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 :)
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top