Select Query Date Problem

[kennedymr2]

I have a select query which has a field MatrixDate (medium Date....eg 11/11/2008
On my form i have a textbox ProcessDate (mediumDate)

In the query criteria in the MatrixDate Column i have
[forms]![Form1]![processdate]

If i run the query without form1 loaded and enter 11/11/2008
it works fine.

But if i have Form1 loaded with 11/11/2008 in a textbox formatted as a mediaum date... it returns no records.

????do i have to put a # or something in the criteria to get it to work ???

Appreciate any help

Regards Kennedymr2

 

[kennedymr2]

Sorry.... i have done a bit more testing, it seems to work.... please ignore this question.. i had a typing error in the program...

Regards Kennedymr2