Calculated Field for Combo Box

[jdks2006]

I am trying to create a table with combo box with multiple values where the data entry person can select multiple items from the combo box. However, in the next field, I am wanting a total calculation of the values selected in the combo box. Does anyone know how to do this?

I currently have two tables: tbl fees, and tbl registration

I have a lookup field in the tbl registration that gets the values from tbl fees.

A registrant can have multiple fees, so I am wanting the data entry person to be able to click on all the fees the registrant is paying for and have a field that calculates the total of all the fees.

My problem, I have no idea how to do that

 

[plog]

I am trying to create a table with combo box with multiple values where the data entry person can select multiple items from the combo box

Its time to make a form. Data entry by users should be done via a form, this will allow you to make data entry easier, eliminate erroneous data and provide them sub-total information like you described.

For this sub-total, your form would have a control that would have as its control source a DSUM (http://www.techonthenet.com/access/functions/domain/dsum.php) which would total up all hte fees for a person.