Slow Form load event (1 Viewer)


Registered User.
Local time
Today, 09:31
May 17, 2012
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.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom