Enter Parameter Value

[The Professor]

Hi,

I've written this SQL string to update the Post Code in the Customer table:

SQL = "UPDATE tblCustomers " & _


"SET [CustPostCode] = " & "[" & strEntry & "]" & _
"WHERE [CustID] = " & ref

DoCmd.RunSQL SQL

I've included the square brackets because without them I was getting a 3075 expression error because the Post Code has a space in it. That error no-longer occurs, instead I'm now getting an "Enter Parameter Value" dialog box showing me the (updated) Post Code, but asking me to enter value - but the Post Code IS the value!

Any ideas?

Prof.

[ranman256]

Brackets are for fields.
Quotes are for strings...(separated below for viewability)

SQL = "UPDATE tblCustomers " & _
"SET [CustPostCode] = ' " & strEntry & " ' WHERE [CustID] = " & ref

[The Professor]

Hi ranman,

Thanks very much for that.

Prof.

[June7]

Brackets can also be used to define other entities: tables, queries, forms, reports, controls. They will be required if naming convention includes spaces or special characters/punctuation (underscore is exception) or reserved words as the full name.