Voila Dsum the answer to all my problems..
Got it with
=DSum("UnitsReceived","T_InventoryTransactions","P artNumberID = [ID]")
Youre a lifesaver John

Barry

"John W. Vinson" wrote:

On Wed, 4 Mar 2009 13:15:02 -0800, Barry A&P
wrote:

John

My Units available is a calculation based on units sold and units purchased.
when i link my Totals query and my part numbers table and a temp table. the
data set becomes un-updatable. The temp table is on each front end to store a
grocery list of parts that need to be ordered until my appent query sends
them to the back end table.

Any ideas??

That doesn't really give me enough of a view of the database to be certain;
but could you perhaps have a textbox on the Form with a control source using
DSum or DCount or DLookUp to display the needed value?
--

John W. Vinson [MVP]