Good day Sir/Ma
Please I have a subform in my order details form and I want to be able to delete records from the subform so I inserted this code in command button of the subform
Private Sub btnDelete_Click()
Call DoCmd.RunCommand(Command:=acCmdDeleteRecord)
End Sub
After clicking on the button it ask if I want the record deleted so it deletes it but
It doesn't update the inventory.
I checked the tables and I tried deleting from it, it deleted but didn't remove it form the inventory
I went to the inventory transaction table to delete, it updated the inventory.
My question is how can I incoporate an sql to delete from inventory transaction table from the button on the subform
Thanks
Please I have a subform in my order details form and I want to be able to delete records from the subform so I inserted this code in command button of the subform
Private Sub btnDelete_Click()
Call DoCmd.RunCommand(Command:=acCmdDeleteRecord)
End Sub
After clicking on the button it ask if I want the record deleted so it deletes it but
It doesn't update the inventory.
I checked the tables and I tried deleting from it, it deleted but didn't remove it form the inventory
I went to the inventory transaction table to delete, it updated the inventory.
My question is how can I incoporate an sql to delete from inventory transaction table from the button on the subform
Thanks
