Need guidance for Inventory dbase, want to avoid calculated field.

[John W. Vinson]

4) That should work, if there's a textbox (not a field) on the form named

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.

 

[plisvb via AccessMonster.com]

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.

 

[plisvb via AccessMonster.com]

Ahhhh,

Figured it out, I knew if was a bonehead mistake. I didn't have macros
enabled by default since upgrading my operating system and reinstalling
office.

Thank you so much for all of you help John, huge help.

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.
[quoted text clipped - 12 lines]

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