Parameter Query Dependent On Which Form Is Open?

  • Thread starter Thread starter Kelvin Middleton
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query Won't Run 0
Parameter Query Depended On Form Loaded? 0
Sources for query parameters 10
How to get a query to call the parameter form 4
Multiple Parameter Crosstab query filter by form 1
Parameter prompt when form is open 2
default value in parameter query 2
Parameter Queries in Crosstab Query 2

Back
Top