Counting data inside Dbcombo box?

[CoMMiE]

Hi
How can i count the number of data that is inside a Dbcombo box?

Thanks in advance

[Buzby]

Assuming you filled the combobox with something like;

MyRS.Open "SELECT name FROM tbl_Names",MyConn

You can use

MyRs.Open "SELECT COUNT(name) AS Total FROM tbl_Names",MyConn
Total=MyRs("Total")

to get the total number if items in the box.

[AlainB]

Well, what about
Total = MyDBCombo.visiblecount
that should work too!