Slow Combo Box (intermittent)

[markmarko]

One of our forms, frmInstallOrders, has about 30 fields, and about 7
subforms. The combo field [JobStatus] on the main form sometimes takes 5-10
seconds to function. For example, user clicks dropdown to choose status, and
it will hang for 5-10 seconds.

The combo control uses a Lookup, with this sql as the row source:
SELECT [List_InstallJobStatuses].[ID],
[List_InstallJobStatuses].[InstallStatus] FROM [List_InstallJobStatuses]
ORDER BY [InstallStatus];

The table [List_InstallJobStatuses] has approx. 25 records, and servers only
as a list for the combo.

Any ideas?

 

[Ken Snell \(MVP\)]

Likely the delay is because the form is still loading the subforms, not
because of the combobox having too many records. If the delay is too long
for your users, you may need to consider making some of the subforms
"invisible" until you actually need them -- that way, ACCESS won't fill them
with data and the delay should be decreased for the combobox.