option groups

[Wendy]

Hi again all,
Can someone tell me if there is a VB way to update an
option group field without sending keystrokes and also
still keeping the focus. I have 10 option groups
consisting of a series of checkboxes in each. I toggle
through each one using the space bar (by trapping
keystrokes on the form and testing if the active field is
an option group). If the last checkbox gets checked I want
the next field to be disabled. I do this using the update
event of the option groups but it only works if I use
arrow keys or click on it. if I use the spacebar routine
to check the box then no update occurs. How do I force an
update without leaving the field?

any help would be greatly appreciated,
Thanks

 

[Graham Mandeno]

Hi Wendy

You can call the AfterUpdate procedure from your code:

Me.MyOptionGroup = SomeNewValue
MyOptionGroup_AfterUpdate

 

[Wendy]

Thanks, but I was looking for a more general solution for
ANY option group rather that writing specific code for
each option group.

thanks again.
Wendy

-----Original Message-----
Hi Wendy

You can call the AfterUpdate procedure from your code:

Me.MyOptionGroup = SomeNewValue
MyOptionGroup_AfterUpdate

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi again all,
Can someone tell me if there is a VB way to update an
option group field without sending keystrokes and also
still keeping the focus. I have 10 option groups
consisting of a series of checkboxes in each. I toggle
through each one using the space bar (by trapping
keystrokes on the form and testing if the active field is
an option group). If the last checkbox gets checked I want
the next field to be disabled. I do this using the update
event of the option groups but it only works if I use
arrow keys or click on it. if I use the spacebar routine
to check the box then no update occurs. How do I force an
update without leaving the field?

any help would be greatly appreciated,
Thanks

.