Help about adding up sums using a checkbox.

[MelonFuel]

Hello Guys

Im trying to get access add up the checkboxes that have been ticked but not add the checkbox i want it to add up what has been ticked not the number of checkboxes ticked. All the fields apart from the total are on a subform.

There will be 4 fields involved.

- Checkboxes
- Quantity
- Price Of Product
- Total

What i would like to know is if its possible for the checkbox when ticked to multiply quantity by price and add it to the total and if the quantity change from say 2 to 5 then it will add what has been changed to the total.



Thanks

[recyan]

Just check if attached sample gives you some guidelines :

Open the form frmMainForm.

melFuel.zip

Thanks