Access - Tabbed Form - Requery works if Step Thru. Errors if Run without Step Thru
Posted on 2013-02-06
I have a Strange Thing Happening......... At least to me it is.........
I have a Tabbed form with each Tab having a Subform Control on every tab....
One of the tabs has a Subform with 6 of its own Subforms. On the 6 subforms (all Single View) there is an unbound field where I calculate some info.
Info from those 6 Subforms via Vb code gets used in some other Tabs Subform Controls.
The First tab of my form has an Unbound Textbox where a user inputs one piece of info. That starts all of the computation via my After_update event of that textbox.
Now then, If I don't put any Breaks in my code it errors out when getting the Computed field from one of those 6 subforms.
HOWEVER, if I put a Break in all the code just before the line where it errors and then step through everything line of code line by line it all works............it is as if just running it happens too quick for those subforms to internally update before the code to get the info for the other forms processes........
Is there a solution to this???????