update subform total to main form field

  • Thread starter Thread starter rudwan
  • Start date Start date
R

rudwan

i have two tables in my file , table1.amount must be
equal to sum(table2.amount) by billno .
through mainform for ( table1 ) and subform form (table2)
i should post the bill details ,
who could total amount of subform will transfer
automatically to amount field in main form ?
notice : any chages to sub form , should automatically
update amount field
 
i have two tables in my file , table1.amount must be
equal to sum(table2.amount) by billno .
Click to expand...

You really don't need the Table1.Amount field; it would be much safer just
to use Sum(Amount) in a query.

Tim F
 
Back
Top