Slow Form load event (1 Viewer)

[liamfitz]

I've got a DB, which has 3 forms ( all 'under' 3 navigation buttons/tabs ). The main form ( Client's form ) is set to show first, and currently has a recordsource of about 1350 records. I think the size of the recordsource, and the fact it 'loads' the other two forms all 'in one go', is slowing it down ( between 5 and 10 secs. to load ). I read I should set the Visible properties of forms, not shown immediately, to false, only setting them to True in the On_Load event - when Tab is selected. Ideal I thought. However, I can't find this property in the Form's property sheet. Any suggestions about the recordsource ( it's a query rather than a string, in case you're wondering, which I know should be quicker running ), and it's size, would also be welcome. Thank you in advance.

 

[boblarson]

Even if they are not visible they would still load their records when the main form opens (in fact, subforms load first before the main form). So, you should have your subforms but no record source for them until you need it. Assign the record source for the subform when it is selected.

See my example here:
http://downloads.btabdevelopment.com/Samples/subforms/Sample-Dynamic_Tab_Loading.zip