Update

[mike60smart]

Hi

Can someone tell me where the syntax is wrong in the following:-

20 strSQL = "UPDATE Part_Number SET Part_Price_Spare2_Notes = "Open" WHERE Job_PartNumber = '" & Me.PartNoID & ";"

The line of Code is highlighted in Red

Any help appreciated

[Welshgasman]

No red.
Debug.print the sql string and post that.
Most likely your double quotes within double quotes?

[mike60smart]

Hi Welshgasman

I should have said that both Job_PartNumber and PartNoID are Strings and I cannot change this.

[mike60smart]

I cannot understand why it is highlighting "open"

[kd2017]

Try

strSQL = "UPDATE Part_Number SET Part_Price_Spare2_Notes = 'Open' WHERE Job_PartNumber = '" & Me.PartNoID & "';"

It's highlighting open because you used double quotes there without escaping. You can use either double " or single ' quotes to open and close a string. If you use double quotes to open and close the string then use single quotation marks to enclose strings within the string, or vise versa. Or you can escape the string characters within the string.
https://software-solutions-online.co...pe-characters/

[Welshgasman]

Hi Welshgasman

I should have said that both Job_PartNumber and PartNoID are Strings and I cannot change this.

Yet you use single quotes for those and double quotes for Open?

You are not even using PartNumber except as a literal.?

[mike60smart]

I was always under the impression if I was using text then they should always be enclosed in Double Quotes.

If I was making a reference to a Control whose data type was Text then use a Single & Double to enclose.

[Welshgasman]

I was always under the impression if I was using text then they should always be enclosed in Double Quotes.

If I was making a reference to a Control whose data type was Text then use a Single & Double to enclose.

Text is text?
So how is Access meant to know when the string ends as opposed to a value being added?

@kd2017 has posted some code, which I would have thought was the solution?, just that I wanted you to think for it by yourself. Have you tried that?

[mike60smart]

Hi KD

That didn't work either - gives the error Too Few Parameters. Expected 1

I have gone with an Update query and it works just fine

Many thanks for looking

[kd2017]

Too Few Parameters. Expected 1

First thing I do when I see that error is double check that table name, field name, and form object names don't have typos.