M mohsinhq Registered User. Local time Today, 14:46 Joined Aug 2, 2004 Messages 90 Sep 13, 2004 #1 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.
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.
Mile-O Back once again... Local time Today, 14:46 Joined Dec 10, 2002 Messages 11,305 Sep 13, 2004 #2 Code: Private Function CountCombo() As Integer CountCombo = Me.MyCombo.ListCount End Sub Put =CountCombo() in your textbox's ControlSource.
Code: Private Function CountCombo() As Integer CountCombo = Me.MyCombo.ListCount End Sub Put =CountCombo() in your textbox's ControlSource.
M mohsinhq Registered User. Local time Today, 14:46 Joined Aug 2, 2004 Messages 90 Sep 13, 2004 #3 thats perfect mate. thanks alot