second Option group not recognized

  • Thread starter Thread starter Molasses26
  • Start date Start date
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!
 
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

Back
Top