odbc call failed when entering query parameter

[BJS]

I have a query that uses an odbc table.
The query prompt for a date: [Enter Date]
After entering the date, I get error: "ODBC Call Failed"

Yet...when I set the criteria to the date I want: #01/01/2005# I can retrieve the data, no problem.

Any idea why I get the ODBC Call Faile error when prompting for the date?

Thanks....
BJS

 

[BJS]

Got it working....after all this time, even though the field in the table was "date/time" format as well as the date be supplied, I needed to use CDate to convert both of them to date.

This only needs to be done when prompting for the date, not when setting the date as the criteria....strange!!!!!!!

Now it works.