Totals on a form

[bgibsonIYD]

I have a form called "Totals", with the fields: TOTAL AMOUNT DUE, AMOUNT PAID, and AMOUNT NOT PAID. I want these fields to be filled in by another form "Registration". The fields to be used are REGISTERED (checkbox), REGISTRATION FEE (listbox), & PAID (checkbox). The TOTAL AMOUNT DUE should be the sum of the REGISTRATION FEE's for all records that the REGISTERED checkbox is set to true. The AMOUNT DUE should be filled in with the sum of all the REGISTRATION FEE's that the REGISTERED checkbox and the PAID checkbox's are both set to true. The AMOUNT NOT PAID field should be the subtraction of the AMOUNT PAID from the TOTAL AMOUNT DUE.

I am having trouble writing the code for this. Can anyone give me some suggestions or help out in any way?

**confused**
Beth
**Learning Access**

 

[mvdmeij]

The form Registration should be based on a table (e.g. tblRegistration) with the fields mentioned.

The form Totals should be based on a query in which you select and aggregate the totals you want.

I don't think you will need any coding....


Good luck,

Mark.