Checking the value of radio button in macro

[Chinmay Bedarkar]

Hello all
I'm a novice at MS Access97. I am creating an Application
in Access in which i have the
following requirements
I have a form in which I fill some search criteria. This
form has a pair of radio buttons.
When i click the 'Search' button, it calls a macro. I have
two different queries; and which
query is to be executed, that depends upon which radio
button was selected. Now i dont know
how to check which radio button is selected.
I am trying
1. isChecked([Forms]![F_Krtrhksk_Search]![rd_hntrhksk]) or
2. [Forms]![F_Krtrhksk_Search]![rd_hntrhksk]=True or
3. [Forms]![F_Krtrhksk_Search]![rd_hntrhksk]='1'
etc...

but none of these seem to be working.
Please guide me.

Thank you.
Chinmay

 

[Ken Snell]

I am assuming that your radio buttons are part of an option group.
Therefore, test the value of the option group, not the value of an
individual radio button.