Count Items in a List Box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a List Box on a form. The number of entries on the list increases as
the user enrolls more attendees in a class. There is a capacity limit to the
number if attendees, so I would like the user to be able to quickly get a the
number enrolled without having to put her finger on the monitor and go " one,
two, three..."

I could write a sum query based on the query that drives the list, and show
the count in a text box on the form, I guess, but that seems a little
heavy-handed. Isn't there a slicker way to do this? Like maybe a function
that would read the list and provide a count?

Thanks!
 
I have a List Box on a form. The number of entries on the list increases as
the user enrolls more attendees in a class. There is a capacity limit to the
number if attendees, so I would like the user to be able to quickly get a the
number enrolled without having to put her finger on the monitor and go " one,
two, three..."

I could write a sum query based on the query that drives the list, and show
the count in a text box on the form, I guess, but that seems a little
heavy-handed. Isn't there a slicker way to do this? Like maybe a function
that would read the list and provide a count?

Thanks!
Click to expand...

Would you believe:
=ListBoxName.Listcount
 
Back
Top