"Date" on a Form that is used in query doesn't work all the time

[bugsy]

Hey

Query is referencing date from a form

This is what query has

<=[Forms]![Form1_MAIN_FORM]![RUN_DATE]

on a form Format is Short Date, Decimal Places - Auto

I've changed General Date, workde once , second time didn't...

 

[KenHigg]

Not sure what you're trying to do but you may want to try:

<=#[Forms]![Form1_MAIN_FORM]![RUN_DATE]#

???
ken

 

[bugsy]

get a error message "the expression you entered has an invalid date value"

 

[Rich]

Is the form still open while the query runs?

 

[GolferGuy]

And if the form is still open, please show us what is in that field on the form.

 

[bugsy]

Yes, the form should be open; that's where the date is coming from.

in the form you just type regular date - like 10/25/31

What I did for now - put a table with one date value, and form now picks up that date. (would be nicer for the old way to start working again)

 

[boblarson]

I think you may need to use 4 digit years.