Access Form/Subform - Subform Unbound Textbox Control Source calc when main form opens
I have a Form with 5 SubForms.
On one of the Subforms I have an unbound textbox that it's control source is to use IIF statements to look at the subform's bound boxes in test them based upon some criteria.
When the Main Form opens, this Subform's unbound box is not updating correctly. It seems that it isn't requerying all of the bound boxes on that Subform to recalc the unbound textbox.
I tried on the subform's OnLoad event to requery each boundbox and requery each unbound box. but it still doesn't update that unbound box correctly.
The Main Form is [frm_Data]
The Subform not updating is [frm_Documents]
The unbound boxes that have to be calced in order are
Is there a way on the load of that Main form to force it to recalc or requery all of the forms. The subform works right if I physically select each individual bound box on the sub even if I leave it null.
8/22/2022 - Mon
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst