This is really just a question for discussion and not a problem that needs solving.
I have a form bound to a table, this table has related tables. My form has various buttons that manipulate records in the related tables. When I click these buttons I'm forced to run requeries on relevant listboxes, subforms, etc to show the results of the manipulations, this is what I would fully expect.
Here's the funny part I did not expect: I have a textbox on the main form that has a control source linking back to a vba function I've defined in the form's module. This vba function runs an aggregate query on related tables and returns the result, the textbox displays the result. What's funny is the textbox automatically refreshes without me having to requery it...?
It doesn't seem to matter how the related tables were manipulated, from my main form or from a subform, the textbox automatically runs the vba function I defined and refreshes itself.
Where is the trigger here exactly? Is this auto-refresh reliable or should I hard code refreshes at appropriate times?