Option button click even 1

[barnard89]

Hi

I am using Access 2000
I have an option Frame with two option buttons "Male"
and "Female"
When the option button "Male" is clicked
"Procedure A" has to be invoked and if option Button "Female" is clicked "Procedure B" has to be invoked


But unlike Visual Basic Applications , I do not see an Option_Click event for these option buttons inside thes option frames

How can I invoke these procedures when the options are clicked
Please advise
The only other events I see are GotFocus, LostFocus, Mouseup and Mousedown , but they seem to be a bit irrelevant

Please suggest the necessary method

 

[PHV]

In the AfterUpdate event procedure of the frame:
If Me![OptionGroup name].Value = 1 Then
ProcedureA
ElseIf Me![OptionGroup name].Value = 2 Then
ProcedureB
Else
MsgBox "unknow gender"
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886