Solved Error 3077 (1 Viewer)

[Kayleigh]

Hi I've written this line of code which compiles without problem but when executed I get a run time error 3077.

 rst2.FindFirst "[fldDate] = #" & Format(d, "mm\/dd\/yy") & "# AND [fldSLStart] = #" & Format(#1:00:00 PM#, "hh:mm:ss AMPM") & "# AND [fldNote] =" & strNote

Can anyone figure out why?

 

[bob fitz]

Perhaps:
rst2.FindFirst "[fldDate] = #" & Format(d, "mm\/dd\/yy") & "# AND [fldSLStart] = #" & Format(#1:00:00 PM#, "hh:mm:ss AMPM") & "# AND [fldNote] ='" & strNote & "'"

 

[arnelgp]

rst2.FindFirst "[fldDate] = #" & Format(d, "mm\/dd\/yyyy") & "# AND [fldSLStart] = #13:00:00# AND [fldNote] ='" & strNote & "'"

 

[Kayleigh]

Worked! Thanks