Hi all,
I'm having a bit of trouble with the VBA side of access.
I have a subform that i'm using VBA to perform a specific calculation (inventory), i can do that no problem but when i do this it's only being applied to one row in the subform when i want to to apply to all of the rows. So the idea is that when "Process Order" is clicked it will subtract the required quantity from the current inventory.
my code is:
[Kit Supporting Subform].Form![Current Inventory] = [Kit Supporting Subform].Form![Current Inventory] - [Kit Supporting Subform].Form![Quantity]
Any help would be greatly appreciated.
Regards,
Hek
Form for reference:
I'm having a bit of trouble with the VBA side of access.
I have a subform that i'm using VBA to perform a specific calculation (inventory), i can do that no problem but when i do this it's only being applied to one row in the subform when i want to to apply to all of the rows. So the idea is that when "Process Order" is clicked it will subtract the required quantity from the current inventory.
my code is:
[Kit Supporting Subform].Form![Current Inventory] = [Kit Supporting Subform].Form![Current Inventory] - [Kit Supporting Subform].Form![Quantity]
Any help would be greatly appreciated.
Regards,
Hek
Form for reference: