I made an option group in my MS Access form.
I need to store the option value of that particular option button, when it is clicked, into my database but there is no 'Click event' for option buttons and the GotFocus,KeyPress,MouseDown dont help.
Please suggest me a way in which I can store the Optionvalue into a table..

Always fall back to the AfterUpdate event when you want to know the value of something after it has changed. In this case, use the AfterUpdate event of the Frame that you used to create the option group.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org