update subform total to main form field

[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

 

[Tim Ferguson]

i have two tables in my file , table1.amount must be
equal to sum(table2.amount) by billno .

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

Tim F