Forum Discussion
Solved
Refresh Sum in form
Hello Experts, I have a form in datasheet. There is a sum in one of the columns (I used the sum button and choose "sum" in the combo box in the record below) When I change a value in the recor...
- Changes to records are not saved until you move off that record or click Enter (which has the same effect). That behaviour is by design in Access databases.
Your code will not work - the form has not been updated whilst you remain on the record.
Once you leave the record, the update occurs automatically with no need to requery, recalc, refresh or even repaint!
Changes to records are not saved until you move off that record or click Enter (which has the same effect). That behaviour is by design in Access databases.
Your code will not work - the form has not been updated whilst you remain on the record.
Once you leave the record, the update occurs automatically with no need to requery, recalc, refresh or even repaint!
Your code will not work - the form has not been updated whilst you remain on the record.
Once you leave the record, the update occurs automatically with no need to requery, recalc, refresh or even repaint!