Update query

[deepucec9]

How to update value from unbound text box to table.
tried the following
DoCmd.RunSQL "Update in SET remquantity_in =" & Me!Text35 & "where out.productid_out = in.productid_in AND out.ponumber_out = in.ponumber_in'"

but it shows RUN TIME ERROR 3144
Syntax error in UPDATE statement
Please help
Note: recordset type of form is Dynaset (Inconsistent updates) changed when I got some error

[alansidman]

Watch this video http://www.datapigtechnologies.com/f...rdsnocode.html

[deepucec9]

Thank you for the reply, did the same but data is not updated in the table. I want to update to specific record eg: ponumber_out=ponumber_in

[orange]

I suggest you dim a string variable

DIm strVar as String
strVar = "Update in SET remquantity_in ="
strVar = strVar & Me.Text35
strvar = strVar & "where out.productid_out = in.productid_in AND out.ponumber_out = in.ponumber_in'"
Debug.print strVar

But, you have a single quote after '"where out.productid_out = in.productid_in AND out.ponumber_out = in.ponumber_in'"
Debug.print strVar

But, you have a single quote after in.ponumber_in'???

Bottom line is, build your sql using string variable, then test your constructed SQL using debug.print.

The output of the debug print should be a valid, rendered SQL statement that you could execute in the query designer.

[InsuranceGuy]

From your post:

DoCmd.RunSQL "Update in SET remquantity_in =" & Me!Text35 & "where out.productid_out = in.productid_in AND out.ponumber_out = in.ponumber_in'"

Try this:

DoCmd.RunSQL "Update in SET remquantity_in =" & Me!Text35 & " where out.productid_out = in.productid_in AND out.ponumber_out = in.ponumber_in"

Assuming all productid and ponumbers are numeric/non-text. I removed an errant apostrophe and added a missing space.