I have a two-part problem with subforms not loading, no pattern that I can figure out. When I open a form containing a subform, sometimes instead of showing rows of data, it's just a blank, white blob where the subform should be -- OR, when my code tries to set the recordsource for the subform dynamically as the main form is opening, it will say that the form doesn't exist or isn't open (even though it works other times). Well, the form DOES exist, and it SHOULD be open, since subforms load before the main form.
The second part of the problem is that when I close that form, part of my close method says
DoCmd.OpenForm 'A'
Forms!A.Somefieldname = "dog".
I just opened form A, and I'll get a message saying that "A" is not open. This problem ONLY occurs when I have the problem where the subform doesn't load.
Help! Any ideas?
The second part of the problem is that when I close that form, part of my close method says
DoCmd.OpenForm 'A'
Forms!A.Somefieldname = "dog".
I just opened form A, and I'll get a message saying that "A" is not open. This problem ONLY occurs when I have the problem where the subform doesn't load.
Help! Any ideas?
