Listbox vs Subform and getting Sum onmainform

[Ruegen]

I have a subform and a listbox on a mainform



the mainform determines the date range for each query of those two objects.

It pulls up the records fine.

so, I have a header on the subform which has a SUM() that sums a column using an unbound text box and the expression sum([Totals])

I'd like to have the same thing but on the main form but for the listbox

I would like to put an unbound textbox on the mainform and have it point to the column in the expression of the listbox.

Possible?

[June7]

Can't Sum() listbox column.

[ItsMe]

What information are you trying to get from your listbox? Is it set to allow multiselct?

[Ruegen]

What information are you trying to get from your listbox? Is it set to allow multiselct?

nope, just a group list with some count. June is right I think. Kind of annoyed that it isn't standard that you can. I'm having to create a subform if I want to view a total.

[ipisors]

It is very possible, you'll just need to write a bit of code for it.

Which column of the listbox do the numerical values appear? And what kind of form is this - single/regular, continuous , etc?
And when do you want to update this textbox's Sum function?