Search date got an error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Back
Top