Syntax Error (Missing Operator) after converting Update Query to SQL 1

[Boham]

In an attempt to speed things up, I converted a working Update Query to SQL. Now when the expression is run, I am receiving a Syntax Error (Missing Operator) in query expression. Through my own investigation, the SQL Statement appears to be correct, Can someone with more knowledge than I point me to the error I made?

Dim SQL As String

SQL = "UPDATE Pub_Index " & _
"Set Unit_Cost = Forms!PurchaseOrders![Purchase Order Details Subform].Form!ItemCost / Forms!PurchaseOrders![Purchase Order Details Subform].Form!Quantity" & _
"Where Pub_Index.Pub_No = PurchaseOrderDetails.Pub_No"

DoCmd.RunSQL SQL

 

[PHV]

1) Put a space before the Where keyword.
2) As the PurchaseOrderDetails table is not declared, I presume you wanted this:
" WHERE Pub_Index.Pub_No = Forms!PurchaseOrders![Purchase Order Details Subform].Form!Pub_No"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Boham]

That worked Perfectly! Thank you sooo much PH