Did that, I've added the field to the table and form's record source and
still a no go.

I no longer have the #NAME? error but the field still doesn't seem to update
at all.

John W. Vinson wrote:
4) That should work, if there's a textbox (not a field) on the form named
Current_Price.

This was a problem, I was using a field, I'm now using a textbox but whenever
I try to bind the textbox to my inventory transactions Current Price field I
get a #NAME? error.

If you added the currentprice field to the table, it is probably not yet in
the Form's Recordsource. Open the Form in design view. View its Properties;
the first property on the Data tab will be the Recordsource. Click the ...
icon by it, and open it in query design view (if Access asks if you want to
create a query, accept the offer). Add the new field to the query and close
the query design window; accept Access' offer to save the SQL.

You should now be able to use currentprice as the control source of the
textbox.

--
Message posted via http://www.accessmonster.com