Forms, SubForms

  • Thread starter Thread starter Jean-Raul
  • Start date Start date
J

Jean-Raul

I am attempting to perform a calculation in an unbound
control which resides in the subform. The Parent Data
exists at the Form Level and Child Data is subtotaled at
the subform level. The form emulates an invoice. The end
result should show subtotaled Child Data being subtracted
from Base Amounts in the Parent. Can anyone offer any
suggestions of how to make this happen?

Thanks in advance for any suggestions.
 
From what I understand there is basically two controls in which the final calculation needs its data from. You have a parent control which I will refer to as [parent] and a subtotaled child control which I will refer to as [child]. For simplicity sake lets say that this is an invoice. The [parent] data will consist of a credit applied to a customer of $100. In the subform there is a list of purchases against the customers credit. These purchases are totaled in [child]. So to find the balance between debits and credits we will need to perform [parent]-[child]

Depending on where the total calculation will be performed will change the code for the [total] control. You will need to add this to the control source of the [total] contro

If [control] is in the parent I will suggest

=[parent] - Forms!["name of parent form"].Form!["name of subform]![child

If in chil

=Forms!["name of parent form]![parent]-[child

HOPE THIS HELP

JT
 
Back
Top