option button values 1

[barnard89]

Hi

I am using Access 2000
I am using an Option group where I have 2 option buttons
opt_male and opt_female

In a command_click event , I wrote the following code

If opt_male is checked to true
It should give a message box
"You checked male option"
if opt_female is checked to true it should give
"You checked female option"

This the code that I wrote , but it is not working . Could any one please correct my code ?

if opt_male.value = 1 then
msgbox "You checked male option"
endif

if opt_female.value = 1 then
msgbox "You checked female option"
endif

 

[PHV]

If Me![name of frame].Value = 1 Then
MsgBox "You checked male option"
ElseIf Me![name of frame].Value = 2 Then
MsgBox "You checked female option"
Else
MsgBox "You checked option " & Me![name of frame].Value
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