CHOOSE function not behaving as expected

M

mikes

I'm trying to use the CHOOSE function as criteria in a query.

Of course, it's pointed to an option group on a form. The form's
option group has values 1, 2, and 3.

It's expression is
Choose([Forms]![frmLocation]![fraLicType],1700,2700,([tblLicenseType].[LicenseType])=1700
Or ([tblLicenseType].[LicenseType])=2700)

where 1700 is the criteria if the first option button is selected, 2700
is the criteria if the second option button is selected, or EITHER 1700
or 2700 is the criteria if the third option button is selected. Note
that the criteria is numeric, not text.

Both the first and second option button selections drive the query
correctly. However, if the third option button is selected, I get ZERO
records returned by the query.

If I put only '1700 Or 2700' (wihtout the quotes) in the criteria
itself, it does return all records as expected.

Any thoughts as to why the multiple conditions in the third argument of
the Choose function fails?

Thanks in advance,
Mike Schoonmaker
 
K

Ken Snell [MVP]

Because you're trying to use Choose in a way for which it's not designed.
Choose will not return a "criteria" expression, it returns a value (number
or string) from the choices that are given.

You'll need a different approach for your query's criterion expression. Just
guessing, something like this, perhaps:

WHERE [tblLicenseType].[LicenseType] =
Choose([Forms]![frmLocation]![fraLicType],1700,2700,1700)
OR [tblLicenseType].[LicenseType] =
Choose([Forms]![frmLocation]![fraLicType],1700,2700,2700)
 
Top