Counting Records in a combo box

[Don]

If I create a list box, I can create a text box and enter the following:
[lstBOX].ListCount, and get the total number of records in the underlying
query tied to the list box; it also allows the list to scroll without me
first having to scroll to the bottom of the listbox. I cannot do the same
thing to a combo box.

Can someone tell me how to retun the number of records in the underlying
queryhh of a combo box and also allow me to scroll to the bottom of the combo
box and have the list actually scroll without me having to go to the last
record first? Thanks.

 

[Marshall Barton]

If I create a list box, I can create a text box and enter the following:
[lstBOX].ListCount, and get the total number of records in the underlying
query tied to the list box; it also allows the list to scroll without me
first having to scroll to the bottom of the listbox. I cannot do the same
thing to a combo box.

Can someone tell me how to retun the number of records in the underlying
queryhh of a combo box and also allow me to scroll to the bottom of the combo
box and have the list actually scroll without me having to go to the last
record first?

I have always done that using a line of code in the form's
Load event:

Me.thetextbox = Me.thecombobox.ListCount

 

[Don]

You are the man! I learned something, today.
--
Don Rountree

If I create a list box, I can create a text box and enter the following:
[lstBOX].ListCount, and get the total number of records in the underlying
query tied to the list box; it also allows the list to scroll without me
first having to scroll to the bottom of the listbox. I cannot do the same
thing to a combo box.

Can someone tell me how to retun the number of records in the underlying
queryhh of a combo box and also allow me to scroll to the bottom of the combo
box and have the list actually scroll without me having to go to the last
record first?

I have always done that using a line of code in the form's
Load event:

Me.thetextbox = Me.thecombobox.ListCount