Sub form problem

[Stuart Green]

I am trying to write a system to control debts my company have. There are lots of case records that may form the debt and I have these listed in a subform which has a calculating unbound box in the subform footer that shows the total debt for the customer. When we have decided to write off these debts I want to record just one record in another table which not only records the total value of the debt being written off but also how its is broken down (interest, penalties etc). This analysis is not recorded in the "many" table and can't be for various operational reasons. I would like to validate that the figures recorded in the one form agree with the total debt shown on the subform when a button is pressed. When I try to do this validation I get problems with the subform not having focus and so the validation (which I have in a macro) comes up with an error (can't find the control). Is there any way to do this please?

 

[Rich]

Pass the value of the Summed total to the new form when opening it

 

[Stuart Green]

Thanks rich. I also noted that I was not refering to the full name of the sub form (I needed to include the mother form and child form name, eg I ws looking at [forms]![subform]![field] when I should have used [forms]![motherform]![subform]![field])