I am using the following code to do a search within my main data entry form:
Private Sub cboOrderSearch_AfterUpdate()
Me.RecordsetClone.FindFirst "[OrderID] = " & Me!cboOrderSearch
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
The issue I am running into is when I delete the search criteria I get the following message:
Run-time error '3077':
Syntax error (missing operator) in expression.
It doesn't affect use of the form but is a little annoying. Any help would be appreciated. TIA