Hello Duncan
Toppers'last suggestion does not work for me so I gather it won't either for
you?

Dates appear in the correct format (ie dd/mm/yy) when I use this:
CriteriaOne = Format(Me.TextBox1.Value, "mm/dd/yy")
CriteriaTwo = Format(Me.TextBox2.Value, "mm/dd/yy")

A little bit confusing but it works correctly with my filter!

HTH
Cordilly
Pascal

"Duncan" a écrit dans le message de
news: ...
Thank you Bob and Toppers but nope, the cdate didnt work.

Cant figure out why................