calculating items in a list box

[metrodub]

On a form, I have a list of classes. When a user chooses a class, the associated materials and their price are shown in a list box.

Is there a way to calculate the items in the list box (ie: handbook costs $10, notepad $3...total in textbox = $13)?

Is having the items placed in a list box the best way to do such a thing? I've done the same with a sub-form, but it's just not attractive.

Thanks in advance.

 

[jebry]

Hi!

You can try putting a text box below the list box and set the control source to:

=DSum("Price", "YourTableOrQuery", "YourClassField = '" & Me!YourClassTextBox.Value & "'")

Once the class is chosen you can refresh the text box.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[metrodub]

Thanks, it worked.