Is there any way I can find out how many rows in a combo box?

[Stapes]

Hi

I have a combo box that displays all the records in my database that
match a record being imported, using the postcode. Is there any way I
can determine, for the current record, how many rows are in the combo
box. i.e If there are > 1 row displayed.

Stapes

 

[Pieter Wijnen]

Totaly useless example:

Private Sub Form_Current()
Dim Cb As Access.ComboBox

set Cb = Me.Combo0
Debug.Print Cb.ListCount
End Sub

HTH

Pieter

 

[Guest]

What is the source for the combo? You can take a record count off that.

 

[UpRider]

Steve, put this in the form's current event:
Dim rst As DAO.Recordset
Dim strSQL As String
strSQL = Combo10.RowSource
Set rst = CurrentDb.OpenRecordset(strSQL, dbOpenSnapshot)
If rst.RecordCount > 0 Then
rst.MoveLast
txtComboCount = rst.RecordCount
End If
combo10 is the name of your combobox,
txtComboCount is a textbox that will display the count.

UpRider