PC Review


Reply
Thread Tools Rate Thread

List box loads slowly first time but quicker on subsequent requerying

 
 
rbm
Guest
Posts: n/a
 
      8th Mar 2012
On my form, I have, among other things, a list box (lstAssets) and a
combo box (cmbSystem). On selecting a value in the combo box, the
list box is populated with data that applies to the system selected.
When the form is initially opened, the row source of the list box is
blank (I did this to speed up the opening of this form).

On selecting a system from cmbSystem, the row source of the list box
is assigned (a simple query that retrieves about 10 fileds from a
table) and the list box is populated. This works fine, but there is
one peculiar issue I would like to resolve if possible.

The first time this list box is populated, it takes about 20 seconds
to load. The table that it is pulling data from is fairly large -
about 66000 records. If I select a different value in cmbSystem, the
list box re-populates almost instantaneously. The On-Click procedure
for cmbSystem reassigns the list box row source (me.lstbox.rowsource =
"qryAssets_All" or me.lstbox.rowsource = "qryAssets_InScope" depending
on the state of another radio button on the form)

What is happening the first time that isn't reproduced in subsequent
requerying? Is there anything I can do to speed up the initial query?

Thanks in advance.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2007 loads open/loads very SLOWLY, even blank new docs Ted Microsoft Word Document Management 6 9th Jun 2008 06:08 AM
First page loads OK then stalls for any subsequent page =?Utf-8?B?TWljaGFlbCBC?= Windows XP Internet Explorer 3 21st Jan 2005 09:06 PM
Capitalise first and subsequent first letters of words =?Utf-8?B?UE1L?= Microsoft Access 1 20th Apr 2004 11:59 AM
Outlook Express loads slowly [really slowly] Dave Windows XP Performance 0 24th Mar 2004 12:37 AM
IE6 loads pages slowly but other browser load fine? Charles Tomaras Windows XP Internet Explorer 1 29th Jul 2003 04:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:02 AM.