Parameter Query Depended On Form Loaded?

K

Kelv

Joined
May 22, 2006
Messages
3
Reaction score
0
Hi, is is possible to create an IIF statement within a query whose parameter says something like...

IIF(FormA is open,FormA.txtParameter,FormB.txtParameter)

I've been trying alsorts but am flying blind, plenty of search results which describe the IsLoaded property when using VBA but I can't fathom how or if this can be ported into a query.

Thanks in advance,

Kelvin
 

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 Dependent On Which Form Is Open? 1
Prompting for a parameter in a query when one isnt present 2
Parameter Query based on Form 2
parameter with iif statement in query criteria 8
Can you use query fields as function variables? 6
True/False Parameter query 2
Parameter Query Form Help 2
Multiple Parameter Crosstab query filter by form 1

Back
Top