It seems like after opening a certain number of forms & subforms Access stops responding or opening new ones.
This number varies but I've created a test database that opens multiple instances of the same form.
No idea why this happens so please feel free to post here any thoughts you might have.
You can download my test database from http://www.4shared.com/file/96022333/4dce8baf/AccessMultiformBug.html
You'll probably ask why I need so many forms open so here's the reason:
I've created dinamic dashboards using multiple subforms on one form.
The subforms themselves have datasheet subforms when that is required.
So if I have a dashboard showing 10 panels (subforms), each of them with a subform for the datasheet I easily end up with 21 forms open at once on just one window.
If I open more than 4 dashboards of this sort, the database starts acting up: most of the time it simply doesn't load forms. Other times it give errors.
Thanks for any ideas!
No comments:
Post a Comment