Not in List syntax error

[Guest]

I have code in the Not In List event to open a form to add a name. All that
is fine but when I close the form I get this error message "Syntax error
(missing operator) in query expression 'Vendor Name = "Master Fabricators'".
The following line is highlighted.

If Not IsNull(DLookup("VendorID", "tblVendors", "Vendor Name = """ & _
NewData & """")) Then

I'm unable to spot anything different from another instance where all works.
Can someone tell me what I'm missing?
Thanks

 

[George Nicholson]

Since your field name includes a space, you should enclose it in brackets:
[Vendor Name]

My guess is that isn't an issue in the 'other instance where it all
works' -and a good reason to never let spaces creep into field names

HTH,

 

[Guest]

Thanks for your help!

Since your field name includes a space, you should enclose it in brackets:
[Vendor Name]

My guess is that isn't an issue in the 'other instance where it all
works' -and a good reason to never let spaces creep into field names

HTH,

I have code in the Not In List event to open a form to add a name. All
that
is fine but when I close the form I get this error message "Syntax error
(missing operator) in query expression 'Vendor Name = "Master
Fabricators'".
The following line is highlighted.

If Not IsNull(DLookup("VendorID", "tblVendors", "Vendor Name = """ & _
NewData & """")) Then

I'm unable to spot anything different from another instance where all
works.
Can someone tell me what I'm missing?
Thanks