Save record in subform

  • Thread starter Thread starter Ken Ivins
  • Start date Start date
K

Ken Ivins

I do a after update event in a field in a subform (multiple payments to a
job). Then I have it requery to calculate the balance due. When I do the
entire database crashes. What is the problem and is there a different way to
accomplish this other than leaving the record and returning back to it?

Thanks,
Ken
 
Ken:

I assume the main form is the Job, and the subform is a payment event for
each related job?

Base the total payments field in the master form on a query or DSum
function.

Enter you detail records.

Then refresh, not requery the main form, after insert/updating detail
records, would be one approach. There are many ways of doing this. You can
execute a function that recalculates the main form sum or value.
 
Greg,

Yea that did it. Thanks,
Ken


Greg Doudna said:
Ken:

I assume the main form is the Job, and the subform is a payment event for
each related job?

Base the total payments field in the master form on a query or DSum
function.

Enter you detail records.

Then refresh, not requery the main form, after insert/updating detail
records, would be one approach. There are many ways of doing this. You can
execute a function that recalculates the main form sum or value.


way
Click to expand...
 
Back
Top