Populated combo box once when form loads

  • Thread starter Thread starter lbernarde
  • Start date Start date
L

lbernarde

I have a combo box that takes too long to query, so I wanted to run the query
once, probably when the form loads, populate the combo box and not have to
requery it again. I did some searching on the site, found things I thought
should help but can't get them to work, so want to start from scratch.
Thanks
 
lbernarde said:
I have a combo box that takes too long to query, so I wanted to run the query
once, probably when the form loads, populate the combo box and not have to
requery it again. I did some searching on the site, found things I thought
should help but can't get them to work, so want to start from scratch.
Click to expand...


You can force a combo/list box to fully "populate" its list
by using a line of code in the form's Load event
lngjunk = Me.thecombobox.ListCount

That has nothing to do with requerying the combo box, which
needs to be done when you need to reload the list. There is
no way to avoid that beyond avoiding the need to reload the
list.
 
Back
Top