By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,761 Members | 1,879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,761 IT Pros & Developers. It's quick & easy.

Read records only when clicked

P: 30
I have tables that are acquiring much data. I also have included a table with pictures. Over the last year the Main form that is opened takes close to 5 minutes at times. I would like have Access not load all the subforms, especially the pictures, unless they are needed--possibly by clicking a button somewhere
The other subforms are all contained in a single tab control.

Thanks
Mar 20 '12 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,489
You could consider setting the name of the form in the SubForm controls to be empty in either the design or maybe even in the FormOpen() event procedure of your main form, and setting them up properly only when triggered.
Mar 20 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.