Access DB

[McDuk]

I keep getting the message;

Run-time error '3077':
Syntax error (missing operator) in expression.

behind the click() event of a command button on a form that is supposed to add details to the underlying recordset of the form which is set on form_load.

The code that is highlighted when I try to debug is;

recordset.FindFirst "VendorName='" & txtVendorNAme & "'"

I'm pretty sure I've got the syntax correct.

[faulkner132]

Try using txtVendorName.Text (in access it may be txtVendorName.Caption) instead of just txtVendorName