Count field

[Matizo]

Hi,

How do I make a field on a form that shows (counts) the number of records selected on a list box?

Thank You!

 

[John Big Booty]

Add an unbound text box to your form an put the following in it's Control Source;

=[ListBoxName].[ListCount]

 

[Matizo]

Hi John,

Thanks for that. How do I change it so that it shows not the number of all employees in the list box but only the number of selected employees? (This is multiselection listbox).


Cheers

 

[John Big Booty]

Sorry my bad

Have a look at .ItemsSelected and .Count


I've not tested this but try;

=[ListBoxName].[ItemsSelected].[Count]

 

[boblarson]

I've not tested this but try;

=[ListBoxName].[ItemsSelected].[Count]

Yep, I tested and it works great.

 

[Matizo]

Hi,

yes it works for me too

However, I figured out that it will be better to use it as a code:

Private Sub lstEmployees_AfterUpdate()

   Me.txtCount = Me.lstEmployees.ItemsSelected.Count
 
End Sub

This way I get instant update whenever I select/unselect a record in the box

Cheers!

 

[boblarson]

I get an instant update using the control source binding method.