How to speed up form loading process

[Benjamins via AccessMonster.com]

Hi,

I have a form where during loading, it check which cotrols is visible and
which is not.

For one the controls, it uses DCount as condition where if Dcount result is
more than 0 it become visible or else it is hidden. This condition itself
take 10 sec to complete while the others uses less than a sec.

Is there a way to speed up the process?

 

[Arvin Meyer MVP]

DCount is a bit slower than building a recordset and doing a record count,
but it shouldn't be that slow. Are you using an indexed value to count on?
If not, use a recordset and count it.

 

[Benjamins via AccessMonster.com]

Yes, the value is indexed.

I will try using the recordset. Thanks for the advise.

DCount is a bit slower than building a recordset and doing a record count,
but it shouldn't be that slow. Are you using an indexed value to count on?
If not, use a recordset and count it.

Hi,

[quoted text clipped - 7 lines]

Is there a way to speed up the process?