Combo box doesn't move to the end of table

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

Hello,


I have a combo box in a form in order to select a record
from a table of 514 records .
When I open the form and scroll down the table by draging
the cursor quickly in the right scroll bar I can't go
beyond the record 218 . When I scroll down by clicking the
arrow in the scroll bar, I can reach the last record, but
it is very slow.
When after opening the form I type the value of the first
index of the last record, the last record is selected and
then I can move by dragging the cursor thrue all records
of the wohle table.
By the way, can somebody tell me how to move in the combo
box with the mouse wheel.

Thanks

Jean

P.S. I have an office 2000 version.
 
Jean,

One way to force Access to load all records into a combobox, is to use
code as follows, in an appropriate event, maybe the On Enter event of
the combobox, or the On Load event of the form...

Dim lngTemp As Long
lngTemp = Me.NameOfCombobox.ListCount

- Steve Schapel, Microsoft Access MVP
 
Back
Top