Link to home
Start Free TrialLog in
Avatar of sonmic
sonmic

asked on

Slow combobox in access

Hi,
I have an access database. The Frontend DB is installed local on my PC and the Backend on the server. When I open the combobox in the main-form then that take about 1 minute (the combobox contains approximately 1000 records). When i open this combobex a second time, then it opens immediately.
What is the reason for this delay?
Tx
ASKER CERTIFIED SOLUTION
Avatar of Natchiket
Natchiket
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It'll be the transfer of data from the server and the build of the rowsource i guess.
If the rowsource data does not change during a session then you could think about copying it into a local table as the database opens, and then using the local table as the rowsource.
sonmic,

Just FYI,

There is a school of thought that would question why you are displayng 1000 items in a combobox.
;-)

If you narrowed down that list, it may be faster.

For example, if this is a list of Customers, have a selection somwhere to limit the customers to a certain geographic location.

;-)

JeffCoachman