List Box makes form OPen/Load SLOW!!

[SDS100UK]

Hi,

I have a form which has (needs) eleven list boxes on. These list boxes perform calculations on certain figures.

At the moment it takes an age to load the form. There are about 250,000 records in the database, growing at about 1,800 a day.

How can I speed up the form load??

Is there anything else I could try??

Many thanks for your help

Steven

 

[jgoodman00]

I am guessing the calculations rely on all the data being loaded?

If this is not the case, I am sure you could somehow modify the rowsources for the listboxes so that they only select a small amount of the data.

You might want to think about upsizing to SQL server if you have that many records as well... James Goodman