Parameter Query Dependent On Which Form Is Open?

K

Kelvin Middleton

Hi, is it possible to do a parameter query who's parameter is dependent to
which form is open.

I.e.

IFF(FormA.IsLoaded,FormA.parameter,FormB.parameter)

I can think of several alternative solutions to my problem but if what I'm
asking above is possible then I'm guessing it would be the simplest.

Thanks in advance,

Kelvin
 
A

Allen Browne

Parameters in a query are not very powerful, Kelvin.

Better to use an alternative approach that does not require the parameter in
the query, such as applying a Filter to a form, using the WhereCondition of
OpenReport, or assigning a SQL string to the RecordSource of a form, report,
OpenRecordset, or SQL property of the QueryDef.
 
Top