M
M Skabialka
I have a form with a subform. To select data in the subform there is a
combo on the main form that contains the distinct results of a query, and it
returns over 25,000 records.
SELECT DISTINCT CDINDEX.DocNumber FROM CDINDEX ORDER BY CDINDEX.DocNumber;
It is very slow to open the first time but after that selecting a DocNumber
is fast enough.
Should I add the control source to the combo after opening, when the user
selects a DocNumber, or will the first instance of selecting that be just as
slow?
What is the best way to do this? This form opens when the database opens,
and it almost seems that Access has hung for several seconds.
Thanks,
Mich
combo on the main form that contains the distinct results of a query, and it
returns over 25,000 records.
SELECT DISTINCT CDINDEX.DocNumber FROM CDINDEX ORDER BY CDINDEX.DocNumber;
It is very slow to open the first time but after that selecting a DocNumber
is fast enough.
Should I add the control source to the combo after opening, when the user
selects a DocNumber, or will the first instance of selecting that be just as
slow?
What is the best way to do this? This form opens when the database opens,
and it almost seems that Access has hung for several seconds.
Thanks,
Mich