Count ComboBox records

mohsinhq

Registered User.
Local time
Today, 14:46
Joined
Aug 2, 2004
Messages
90
anyone know how to do a count of the records in a combo box.

need the count in a field on the form. not in a query.
 
Code:
Private Function CountCombo() As Integer
    CountCombo = Me.MyCombo.ListCount
End Sub
Put =CountCombo() in your textbox's ControlSource.
 
thats perfect mate. thanks alot
 

Users who are viewing this thread

Back
Top Bottom