Pass value to a query

[dodgyone]

Within my code it checks various things onscreen and places resulting values in text boxes (not the best solution but it works). Within the query it points to these text boxes for it's criteria:

[Forms]![Output Utility]![valCriteria]

The problem is that I want to send the text values "Is Null" or "Is Not Null" which are held in the text box. It is being taken as a string rather a literal command.

Is there any way of passing this to query as it should be interpreted?

 

[stephenk1973]

Try an if statementent.

if([Forms]![Output Utility]![valCriteria]="Null",null,[Forms]![Output Utility]![valCriteria])

You could nest another statement to get the 'is not null'.

hope this helps

Stephen