Search date got an error

[Guest]

Hello,
Please help with this code, I got an error: "Syntax error (Missing operator)
in expression"

.FindFirst "[inv_start_date] = #" & Me.inv_start_date & "# And " _
& "[inv_complete_date]= #" & Me.inv_complete_date & "#" _
& "[Case_no]=" & Me.case_no

Thank you,
MN

 

[Guest]

Please ignore it. I missed an AND after # sign.
It work now....

 

[John Vinson]

Hello,
Please help with this code, I got an error: "Syntax error (Missing operator)
in expression"

.FindFirst "[inv_start_date] = #" & Me.inv_start_date & "# And " _
& "[inv_complete_date]= #" & Me.inv_complete_date & "#" _
& "[Case_no]=" & Me.case_no

Thank you,
MN

You're missing the word AND. If you actually build this concatenated
string with reasonable values, you'll get

[inv_start_date] = #1/15/2005# And [inv_complete_date] =
#3/10/2005#[CaseNo] = 3123

Make the last line

& " AND [Case_no]=" & Me.case_no

and you should be ok.

John W. Vinson[MVP]