Query total and ListBox.

  • Thread starter Thread starter NEMO2K
  • Start date Start date
N

NEMO2K

Hi All,

I've designed a form containing, among others controls, a
ListBox which can show the result of a query following some
selections made by values in ComboBoxes.
Is it possible, and how, obtaining the total sum of a
numeric field in the ListBox (and of the query, of course)
and showing it in the form?
Thanks,

NEMO2K
 
A multiselect listbox has several properties that you can examine.
ListData, ItemsSelected, and some others. You can step through these
properties, and increment a variable to get the sum that you desire.

For more information about coding forms, feel free to visit any of the Forms
newsgroups.
 
Back
Top