I am not entirely sure what you mean by "debug" window. Is that the VBA code
window?

I still get a "missing operator" error. Nothing seems to have changed.

"Rick Brandt" wrote:

"scubadiver" wrote in message
...
Here is the code as it is now.....

Dim rstClone As Object

Set rstClone = Me.RecordsetClone

rstClone.FindFirst "[CustomerName]= '" & Me.Customer & "' And " &
[Forms]![queries form]![Branch form].[Form]![Address1] & " = '" & Me.address
& "'"

Me.Bookmark = rstClone.Bookmark

Set rstClone = Nothing

End Sub

Add this line right after the Set rstClone line...

Debug.print "[CustomerName]= '" & Me.Customer & "' And " & [Forms]![queries
form]![Branch Form].[Form]![Address1] & " = '" & Me.address & "'"

....then check the debug window after running the code. Does the string sent to
the debug window look correct?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com