Combo box loading

  • Thread starter Thread starter Boon
  • Start date Start date
B

Boon

Hi,

I am using a combo box in my form. The combo box links to the list of
numbers from one table. The list is a number from 1 to 1000.

When I open the form in "form view", the first time I click on combo box and
scroll down, the value doesn't scroll along. But after I scroll it to the
very buttom of the list, the value scroll along smoothly. Is it a way to
make this happen right at the first time I click the combo box?

Thanks,
Boon
 
Boon,

In the Form_Load event of the form enter this :-

Dim x

Combo1.Requery
x= Combo1.ListCount

where Combo1 is the name of your combo box control

HTH

Peter Hibbs.
 
Thank you Peter,

Do you know how many items can be in a combo box? I noticed that it can
have only 63553. My list has about 1000000.
What should I do?

Boon
 
Back
Top