Dynamic query dependent on form being open

[philcon]

Hi there,

tried this in the queries forum with no joy, wondered if anyone here could help....

I am wondering whether I can dynamically update a query (standard access, not SQL) dependendent on a certain form being open.

Essentially if said form is open when the query is processed, I wish to use a value from the form as a criteria. However if the form is not open, I do not wish the criteria to be used or I will get a messagebox asking for the "missing" parameter on the lines of.

I know this can be done using SQL/VBA, but can it be done more simply in the query design tool?

Hope you can help


Philcon

 

[Onyxpurr]

I just found this the other day.

I believe if you put "[Forms]![formname].[textbox] or is null" for the criteria it would work.