Update value from unbound text box

[deepcec9]

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

 

[spikepl]

Follow this recipe exactly: http://www.baldyweb.com/immediatewindow.htm

 

[deepcec9]

Thank you for the reply, im new to this system and coding. Can you please explain how to resolve it.