Data1.Recordset.FindFirst "DueDat = search#" Whats Wrong

I am trying to search trough as database.
I want the user to input the info to search for under the DueDat column. It runs but then comes up with a error that says somthing like invalid vale in date in expression what should i do?

[ScottF]

Show some code that way we may be able to help

[preeti]

Hi,

check first that the value that you are passing is a valid date before doing your search.

You can use:

if not isdate(expression) then
msgbox "Invalid date"
else
'code for search
end if

HTH,

Preeti