Update statement problem 1

[iojbr]

Hi:

I keep getting an error message when I try to run this update statement. Is there something wrong with the syntax. Thanks in advance.

S5 = "Update [Safety Stock Base Table] SET [Product Description] = [Forms]![Receiving]!PD ,[SR-3 Requirement] = [Forms]![Receiving]!MSR,[Order Date] = [Forms]![Receiving]!Dt, [Order Time]= [Forms]![Receiving]!Tm WHERE ((([Part Number])= [Forms]![Receiving]!PON ));"

DoCmd.RunSQL S5

 

[Remou]

You need the values for the form data:

S5 = "Update [Safety Stock Base Table] SET [Product Description] = '" & _
[Forms]![Receiving]!PD _
& "',[SR-3 Requirement]='" & [Forms]![Receiving]!MSR _
& "',[Order Date] =#" & Format([Forms]![Receiving]!Dt,"yyyy/mm/dd") _
& "#, [Order Time]=#" & [Forms]![Receiving]!Tm _
& "# WHERE [Part Number]=" & [Forms]![Receiving]!PON

I have guessed at data types for the delimiters.