Checking the value of radio button in macro

  • Thread starter Thread starter Chinmay Bedarkar
  • Start date Start date
C

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
 
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.
 
Back
Top