Hi Vlad
On the Continuous Form I have a Combobox for selecting "Stock" with the following Row Source:-
Code:
SELECT tblStock.StockID, tblStock.PartTypeID, tblStock.Code, tblStock.InvQtyOH FROM tblStock ORDER BY tblStock.Code;
There is a bound Control for "Qty"
I then have an Unbound Control named "StockID" with a Control Source of :-
Code:
=[cboStock].[Column](0)
I then have an Unbound Control named "NewQOH" with a Control Source of:-
Code:
=Nz([Qty],0)+Nz([InvQtyOH],0)
which display the correct values 121 & 10