Query total and ListBox.

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
 
M

[MVP] S.Clark

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Cannot select items in listbox 1
Run select query from VBA code where criteria comes from a multi select ListBox 2
Query results to listbox 7
Multiselect listbox problem in queries 2
how to populate a listboc with the result of two combobox 14
Dynamic sorting of listbox based on crosstab 2
Passing value to Query Criteria from a ListBox 7
Listbox on a form as input for a query 1

Top