asked on
Ms Access SQL not updating when form is open
I have form that prints an Invoice. When the invoice is printed it updates the inventory table to adjust for the number of items sold. I do this with the following statement.
DoCmd.RunSQL "UPDATE tblInvoiceDetail INNER JOIN tblInventoryData ON " _
& "tblInvoiceDetail.Partno = tblInventoryData.Partno SET " _
& " tblInventoryData.QuanInSto
& "WHERE (((tblInvoiceDetail.[InvNo
This works perfectly but if my Inventory form is also open to one fo the items being updated, the update for that item does not occur. What can I do to fix this?
DoCmd.RunSQL "UPDATE tblInvoiceDetail INNER JOIN tblInventoryData ON " _
& "tblInvoiceDetail.Partno = tblInventoryData.Partno SET " _
& " tblInventoryData.QuanInSto
& "WHERE (((tblInvoiceDetail.[InvNo
This works perfectly but if my Inventory form is also open to one fo the items being updated, the update for that item does not occur. What can I do to fix this?
Microsoft Access
Last Comment
EclecticBob
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you, I'd rather not have to close the form but the SaveForm routine looks like the solution.