Set Criteria w/option group

  • Thread starter Thread starter Chuck L
  • Start date Start date
C

Chuck L

I am trying to use an option group to set criteria in one
of my queries.
I would like to give the user the ability to search a
table of data by setting criteria on one of four fields.
The criteria would be set based on a # entered into a text
box. The selected radio button in the option group on my
form would determine which field in the underlying query
the criteria would be set.
I have tried to set IF statements in the criteria of each
of the fields in my query. i.e. IIf([Frame10]=1,[Form]!
[Text0]), etc. I have also tried to use the SetValue
function in a macro, but this only applies to forms and
reports.
My eyes are about to pop out! I know there is a way to do
this, but I'm fried. Help!
Thanks much in advance
My email: charles (dot) ledig (at) penske (dot) com
 
I would like to give the user the ability to search a
table of data by setting criteria on one of four fields.
The criteria would be set based on a # entered into a text
box. The selected radio button in the option group on my
form would determine which field in the underlying query
the criteria would be set.
Click to expand...

Macros aren't going to cut it, I don't think; you'll need to write VBA
code to construct the entire SQL string.
 
Back
Top