listbox Count

[azhar2006]

Hi guys
Have a nice day everyone.
I have a listbox based on a query. I want to put a text box on the form that will collect the records in it (ListCount)

 

[moke123]

in the control source of textbox

= me.YourListBoxName.ListCount

 

[azhar2006]

in the control source of textbox

= me.YourListBoxName.ListCount

Thank you very much moke123
I put it in the VBA editor

Private Sub Form_Current()
'MsgBox "There are " & Me.lstBookings.ListCount & " items in this Listbox."
Me.Text50 = lstBookings.ListCount
End Sub

 

[moke123]

On Current works too.

The difference between the 2 methods is that the Current event will only run once when the form/record changes.
The control source method will update the count if you add an item to the list programmatically.

 

[cheekybuddha]

You probably won't be able to use Me in a ControlSource.

I guess it would be more like:
=[YourListBoxName].ListCount

 

[moke123]

You probably won't be able to use Me in a ControlSource.

I guess it would be more like:
=[YourListBoxName].ListCount

Correct, missed that. Sometimes the Me. keyword is a bad habit.