Update Query Advise on BE SQL and Access FE

[SimonT]

Hi Guys,

I have a form that is used to update prices I have the following sql
statement:

UPDATE products SET products.price =
[price]+[Forms].[frmPriceModify].[txtchange]
WHERE (((products.productID)=[Forms].[frmPriceModify].[productID]));

I am wondering what is the best way to handle something like this, is it
possible to pass the form variables?

Currently this query will not work on the linked SQL tables, but works fine
if I switch to the local access BE

Any suggestions welcome

Si

[a a r o n . k e m p f @gmail.com [MCITP: DBA]]

Dim strSql as string
strSql = "UPDATE products SET products.price = [price]+" & [Forms].
[frmPriceModify].[txtchange] & "WHERE products.productID= " & [Forms].
[frmPriceModify].[productID]

DoCmd.RunSql strSql