Hi all,
Please could you assist?
I select a product from a drop down list, after update it should lookup a value from the same table and update my current table
for some reason it is not doing the update but when I manually click on the update query, I get the write conflict error
My code behind the after update is:
Below is my update query
Please could you assist?
I select a product from a drop down list, after update it should lookup a value from the same table and update my current table
for some reason it is not doing the update but when I manually click on the update query, I get the write conflict error
My code behind the after update is:
Private Sub Product_AfterUpdate()
DoCmd.SetWarnings False
DoCmd.Save
DoCmd.GoToControl "Qty"
DoCmd.OpenQuery "Update Purchase Request - UOM"
DoCmd.SetWarnings True
End Sub
Below is my update query
UPDATE [Transactions - Procurement - Temp] INNER JOIN Products ON [Transactions - Procurement - Temp].Product = Products.[Short Description] SET [Transactions - Procurement - Temp].UOM = [Products]![UOM]
WHERE ((([Transactions - Procurement - Temp].Product)=[Forms]![Purchase Request]![Product]));