Opinion required on how to add calculation

[resolva]

Hey all, sorry for yet another question.

I have a database where delegates are attending workshops.

For each workshop they attend it costs them £50

On the database at the moment I only have a memo field which has the workshops attending. But basically I want to pick from a combo box for each workshop they are attending and then have £50 add up each time.

How would be the best way to do this?

 

[wiklendt]

you can have a textbox on your form which sums up the values in a subform field. for example, if i want to sum the [txtcost] control form the subform [sfrmWorkshopAttendance], then a textbox on the main form can have the source something like:

=sum(forms!frmDelegates.sfrmWorkshopAttendance.form!txtCost)

i think that's the way it works, anyhow! try it and see if that gets you what you need. obviously you need to change the names of things to what you have in your database (frmDelegates; sfrmWorkshopAttendance; and txtCost)