Access 2003 Dropdown slow to load

[pskaalen]

I have a table containing 10,000 records. I have a combo box listing them. Within the box control, I have a SQL string typed into the Record Source. It all works. But the problem is that when I open the combo box and drag the slider bar to the bottom to see the last record, it takes several seconds as the combo box appear to be reading or loading all the records. However, if I click to open the combo box and then click ctrl-End, the box immediately jumps to the last record without delay. I want my users to be able to drag the slider bar up and down to see all the records quickly. One way might be to see if I can insert code so that as soon as the combo box was clicked on the screen, the code would trigger a ctrl-End and then a ctrl-Home to bring the box back to the first top record. That would make the box fully loaded with records so the user could navigate using the slider bar quickly without any delays. But this would not be a very elegant solution and the user would see the box jumping to the last record and then to the first. But if no one has a better idea, I would welcome how that technique could be accomplished.

[pskaalen]

I found that by simply adding the following code to the GotFocus event, it works fine.

Private Sub Combo-name_GotFocus()
Dim lngCount As Long
lngCount = Combo-name.ListCount
End Sub