troubleshooting Question

Access Form/Subform - Subform Unbound Textbox Control Source calc when main form opens

Avatar of wlwebb
wlwebbFlag for United States of America asked on
Microsoft Access
7 Comments1 Solution1108 ViewsLast Modified:
Hello all
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.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros