My database is based on A Mooring stock control System.
i have 3 forms: A 'OrderIN form', A 'SalesOUT form' and a 'Current stock list' form.
I want a macro which will, when someone orders for example, 'Stock A' in the order form, it will add the quantity bought from the amount in the 'stock list' form. and i want a macro which will take away the stock when a certain item is sold.
thankyou for your help. Could you please tell me exactly how to do this. ta.
Turn on thread page Beta
MS Access Urgent Help! watch
- Thread Starter
- 27-02-2004 16:32
- 27-02-2004 20:01
you don't need the StockDescription and QuantityInStock fields on your form
you only need one query, for what you're doing
use an update query
showing tblOrder and tblStock:
ok, you've already entered an amount in tblOrder
show the field QuantityInStock from tblStock in the query
Update to: [tblStock]![QuantityInStock]-[tblOrder]![AMOUNT-ORDERED]
*where amount ordered is your field you're using to add a "quantity" to
this is the important part
that should work
since, you're entering data into frmOrder which is bounded to tblOrder, that's it, you've added an amount.
The query I described above would take an amount away from QuantityInStock field.