Dropdown Scroll

[bandidom9]

I have a dropdown in a form that display over a 100 records. The scroll bar of this dropdown it wont scroll on the first attemp just after doinf the first selection it works. on the first attemp it just jump all the way to the bottom of the dropdown list. Does any one have an idea of why is this happening?

[Rawb]

This is because Access doesn't load the entire Recordset before showing the Combo Box (or anything where a Recordset is used - run a Query on a large Table sometime, you'll notice that it doesn't know how many records are in the result until a few seconds AFTER showing you the results).

One possible solution (although I've never tried it) is to check the Recordset when you "Enter" the Combo Box:

1. User selects the Combo Box and triggers the "On Enter" Event.
2. VBA code loads the Combo Box's Recordset and sets the current value of the Combo Box to the LAST item in the Recordset.
3. VBA code then resets the Combo Box's current value to what it was before the user entered the Control.

Theoretically, that would force the Combo Box to load the entire Recordset, thus allowing the user to scroll properly through it's contents. The tradeoff is that the Form may "freeze" for a split second the first time the VBA code is run and the Combo Box may "flicker" each time it's used (as it jumps to the last entry and then back to where it was).