Hi,
I m working for a furniture recycling charity. I want to be able to finalize an order by pressing a button so that it takes the quantity of ordered stock out of the Stock table (eg someone orders 3 chairs so quantity = quantity - 3).
I currently have it working so that the first one in the list (a tableview subform on the order form) works fine, but the rest dont (say I order 2 chairs and a desk. The chairs come out of Stock but the desk doesnt).
I have 'quantity in stock' as a field on the subform as well as 'quantity ordered'. How can i make it set the 'quantity in stock' for every record in the subform?
Setvalue in the button macro:
Bookmarks