update subform total to main form field

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
 
T

Tim Ferguson

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
 
Top