using formulas as query criteria from a lookup table

[Tfost]

I am trying to set an option on a form (either a lookup table or check box) which will then activate the following criteria in a query <date(). I have tried setting this formula up in the lookup table and I have also tried setting an IIF statement to pass this expression to the query when a checkbox is checked. However I keep getting the same error.

"The expression is typed incorrectly, or is too complex to be evaluated......"

Any help would be extremely gratefully recieved.

 

[Tfost]

I have solved this problem myself if anyone is interested this is how I did it.

i set up a filter in the reports query to search for records which met the criteria <date().

I then used the applyfilter macro command to activate this filter when the correct checkbox is checked.