Search error

A

Alfred FPC

In a Access form that i have, i have 3 fields so that records can be looked
up by either, serial number, property id, or external id number. Whenever i
enter a number into one and go to the next field it gives me a error message
stating : "Run-time error '3077"; Syntax error (missing operator) in
expression."

This is the VB that i am using that seems to be giving me the problems.

Sub Combo48_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[PROPERTY_ID] = " & Me![Combo48]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub


How can i prevent this from happening?

-alfred
 
Top