I have a subform in Ms-Access, with the following information:
Product ID, Description, Quantity, Price, Total (Calculated field).
At the bottom of the form I have a Grand Total calculation.
However, when I change the Quantity, the Grand Total is not updating one time. It is when I press enter(s) until a new record that the Grand Total is updated.
I know that "me.refresh" or "cmdruncommand accmdrefresh" after update (event) Quantity could be a solution.
However, if if use the "Refresh command", the form blinks and it does not look professional (at least for my point of view) when a user types information and the blinking blinking appears.
Is there any other way of getting the Grand Total updated, avoiding the blinking?