FindFirst with Date and String Problem

[EddyLLC]

I'm using the following FindFirst but getting a Invalid Syntax error. Both variables (strNumber1 and strDate) are dimmed as strings. The field [Date] is a date field so I use the CDate to convert the string into a date.

Any thoughs on what I am doing wrong? Thanks

rst.FindFirst "[Number1] = '" & strNumber1 & "' And [Date] = '" & CDate(strDate)

 

[jrbarnett]

Date fields have to be delimited by hash characters. For example:

rst.FindFirst "[Number1] = '" & strNumber1 & "' And [Date] = #" & CDate(strDate) & "#"

John

 

[PHV]

And if the field [Number1] is a numeric field:
rst.FindFirst "[Number1]=" & strNumber1 & " And [Date]=#" & CDate(strDate) & "#"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886