I am querying a dB2 table via ODBC. When I input the date parameter directly into the query criteria (=#06/01/2003#) it works fine. But I don't want the users to be opening up queries and hardcoding stuff in there.

I created a form with an input box. But when I put this in the criteria of the query =forms!frmdashboard.firstdate it tells me the date is out of range. The form textbox is formatted as a date. I have tried using CDate to be sure the format is coming back date.

I thought maybe I need to incorporate the #'s somehow, but I am baffled on how to proceed. I have tried every combination I can think of. -- CB