abitlity to create query off mulitple radio buttons

  • Thread starter Thread starter carroll cauthen
  • Start date Start date
C

carroll cauthen

I have a form with 8 "options" each having three radio
button choices. the user can only select 1 radio button
for each "option" How do I build a query utilizing
selection critiera specified in the radio buttons for each
of the 8 "options" Just to clarify, I don't want to build
8 queries, just 1 query utilizing 8 fields and the
selection criteria of the radio buttons.
 
Each *OptionGroup* has a Value which is the number associated with the
selected RadioButton in the OptionGroup. Thus you can use something like:

.... WHERE [Field1] = Forms!YourForm!YourOptionGroup1

and the Query will only select rows whose Field1 values are the same with
the value selected in OptionGroup1.

If each RadioButton in the Option means something different from the numeric
values associated with the RadioButtons in your database, you will need to
"translate" from the numeric value of the OptionGroup to the assigned
meanings, perhaps using the Choose() or Switch() function.

Check Access VB Help on Choose / Switch.
 
Back
Top