Forum Discussion
Subform saving records before I actually click save
There are two different problems here. Let's address the table design problem first.
In a relational database application we do NOT store calculated values like inventory balance. It's a design choice that seems okay until you try to use it in practice. Don't do it, in other words. Remove that field from the table(s) and delete the table macros trying to update it.
That will actually help address the other issue. I don't call it a problem, per se, because it is just the way Access forms, or I should say bound Access forms, are supposed to work. Changing focus in the form from one record to another automatically saves the record losing focus. So your "Save" button turns out to be redundant.
How do you create a report showing inventory balances, you ask? You do that in an aggregate query which sums up all of the inventory received, all of the inventory used to fill orders, and computes the balance between those two totals.
I suggest you look into the Northwind sample database to get some better insight into valid table design approaches.