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:
Please Login or Register  to view this content.