By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,786 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,786 IT Pros & Developers. It's quick & easy.

I chose toggle buttons in my option group and now my option group isn't being updated when one of them is pressed

P: n/a
MLH
Why is that?

If I choose the tiny check boxes which are hard to
hit with a mouse, it works fine. But option buttions,
shich can be sized big enough for people with limited
sight and dexterity to hit - they don't work at all.

Its true. I created 'em with the built-in wizard furnished
with Access 97 but they do not work. I put 12 of 'em
in the group, labeled the months of the year and giving
them option values 1 through 12. No afterupdate code
fires on click of ANY of the 12 toggle buttons.

Why?
Nov 13 '05 #1
Share this Question
Share on Google+
11 Replies


P: n/a
MLH wrote:
Why is that?

If I choose the tiny check boxes which are hard to
hit with a mouse, it works fine. But option buttions,
shich can be sized big enough for people with limited
sight and dexterity to hit - they don't work at all.

Its true. I created 'em with the built-in wizard furnished
with Access 97 but they do not work. I put 12 of 'em
in the group, labeled the months of the year and giving
them option values 1 through 12. No afterupdate code
fires on click of ANY of the 12 toggle buttons.

Why?


Are you using AfterUpdate of the ToggleButton or of the OptionGroup? You
need to use the latter.

Are you positive you have them *inside* the OptionGroup. If you move the
group to the ToggleButtons move?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
MLH

Are you using AfterUpdate of the ToggleButton or of the OptionGroup? You
need to use the latter. That's the problem. I can't use the latter. I can write code there,
but it does no good. The event doesn't fire. Does it fire for you?
I let the wizard build my option group. Maybe it left something out.
Dunno. But I don't think so. I remember same behavior in Access 2.0.
Are you positive you have them *inside* the OptionGroup. If you move the
group to the ToggleButtons move?

Yes, if I drag the group, the TB's go with it in unison.
Nov 13 '05 #3

P: n/a
MLH

Are you using AfterUpdate of the ToggleButton or of the OptionGroup? You
need to use the latter.

The toggle buttons in the option group do not have after update
events. I don't think they are updateable objects anyway.
Nov 13 '05 #4

P: n/a
MLH wrote:
Are you using AfterUpdate of the ToggleButton or of the
OptionGroup? You need to use the latter.

That's the problem. I can't use the latter. I can write code there,
but it does no good. The event doesn't fire. Does it fire for you?


Are you sure that you have "[Event Procedure]"entered in the event property for
the group?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #5

P: n/a
MLH
Am I sure? As sure as I am that I launched MS Access before
running the procedure. You sould like me when I did tech support...
Is the monitor power cord plugged in? I me into a power outlet?
How about the switch. What I mean - is it flipped to the ON
position?

Here's the only code line in the OG's AU event:
MsgBox "After update event just fired"
Msg never displays after clicking any toggle button.
OG value is NEVER updated. All TB's have option
values set. I'm telling you, it does not work with TB's.
It does work with the radio bttns and check boxes.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Thu, 26 May 2005 11:18:09 GMT, "Rick Brandt"
<ri*********@hotmail.com> wrote:
MLH wrote:
> Are you using AfterUpdate of the ToggleButton or of the
> OptionGroup? You need to use the latter.

That's the problem. I can't use the latter. I can write code there,
but it does no good. The event doesn't fire. Does it fire for you?


Are you sure that you have "[Event Procedure]"entered in the event property for
the group?


Nov 13 '05 #6

P: n/a
MLH wrote:
Am I sure? As sure as I am that I launched MS Access before
running the procedure. You sould like me when I did tech support...
Is the monitor power cord plugged in? I me into a power outlet?
How about the switch. What I mean - is it flipped to the ON
position?
That omission happens all the time in these groups.

Here's the only code line in the OG's AU event:
MsgBox "After update event just fired"
Msg never displays after clicking any toggle button.
OG value is NEVER updated. All TB's have option
values set. I'm telling you, it does not work with TB's.
It does work with the radio bttns and check boxes.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I admit I didn't run a test before because I felt no need to, but I did just now
(Access 97) and I saw the MsgBox in my AfterUpdate event with RadioButtons and
when I changed them to ToggleButtons I still got the MsgBox. I see no change in
behavior at all.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #7

P: n/a
Rick Brandt wrote:
I admit I didn't run a test before because I felt no need to, but I
did just now (Access 97) and I saw the MsgBox in my AfterUpdate event
with RadioButtons and when I changed them to ToggleButtons I still
got the MsgBox. I see no change in behavior at all.


Just got to work and ran the same test in Access 2000, 2002, and 2003. The
AfterUpdate fired correctly in all versions with ToggleButtons.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #8

P: n/a
I also tested in Ac 97: No problem

To MLH: "Try it again, maybe on a blank form (that's what I did ;-)) "
The switch might be in the ON position, but how about the current ??
Do you see the light ?? <g> (just kidding)

I also do tech support sometimes with my own apps...

Arno R

"Rick Brandt" <ri*********@hotmail.com> schreef in bericht news:91****************@newssvr30.news.prodigy.com ...
MLH wrote:
Am I sure? As sure as I am that I launched MS Access before
running the procedure. You sould like me when I did tech support...
Is the monitor power cord plugged in? I me into a power outlet?
How about the switch. What I mean - is it flipped to the ON
position?


That omission happens all the time in these groups.

Here's the only code line in the OG's AU event:
MsgBox "After update event just fired"
Msg never displays after clicking any toggle button.
OG value is NEVER updated. All TB's have option
values set. I'm telling you, it does not work with TB's.
It does work with the radio bttns and check boxes.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



I admit I didn't run a test before because I felt no need to, but I did just now
(Access 97) and I saw the MsgBox in my AfterUpdate event with RadioButtons and
when I changed them to ToggleButtons I still got the MsgBox. I see no change in
behavior at all.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #9

P: n/a
MLH wrote:
Here's the only code line in the OG's AU event:
MsgBox "After update event just fired"
Msg never displays after clicking any toggle button.
OG value is NEVER updated. All TB's have option
values set. I'm telling you, it does not work with TB's.
It does work with the radio bttns and check boxes.


I use toggle buttons all the time in option groups in A97 and A2003 and
have never ever had this problem.

Has the option group been renamed after you put the after update code
in? This will "orphan" blocks of code in your form module (unless name
autocorrect somehow takes care of this, but I have ALWAYS turned name
autocorrupt off after hearing frequent advice from Tony Toews to avoid
this apparantly plagureed feature - could this be part of your problem,
I wonder?)

Though I've never use the wizard to do it. So try building one without
the wizard.

Delete your current option group and build it by using the form design
view tool box. Bring in an option group and enter toggle buttons one at
a time into the option group frame, altering the caption property to the
name of the month. Don't copy existing button - or if you do, make sure
you chnage the option value so that all 12 toggle buttons have different
values. Then set up your after action event for the option group.

That will work. If it doesn't, you're doing somehting fundamentally
wrong I can't figure out from what you've written.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #10

P: n/a
MLH <CR**@NorthState.net> wrote in
news:ef********************************@4ax.com:
Here's the only code line in the OG's AU event:
MsgBox "After update event just fired"
Msg never displays after clicking any toggle button.
OG value is NEVER updated. All TB's have option
values set. I'm telling you, it does not work with TB's.
It does work with the radio bttns and check boxes.


Try copying the code to the clipboard, deleting it from the module,
then going back to the form, click the AfterUpdate event, code, then
paste the code back in.

It's fairly common for the connection between a control's event and
the actual code to be lost, even when the name is correct.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #11

P: n/a
MLH
Tim:

I'll be a son of a gun. You were right. Building it w/o the wizard -
success on the first trial. I have no earthly idea why my wizard
builds 'em to where they won't work. Doing it manually, just like
you suggested is a piece of cake.

Though I've never use the wizard to do it. So try building one without
the wizard.


Nov 13 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.