Is there a way to ...

[bginhb]

I am using a form with a subform - this issue is about the subform.

The subform accesses a dynaset and data can be entered into a quantity field in each record of the subform. Owing to intentional design no records may be added to the subform.

Here's the issue ... the subform also wants to total the amount of the quantity field and display it on the subform heading but if I disallow additions Access will not allow the last record in the dynaset to update and therefore its value will not be added to the total counter that uses a domain aggregate to sum the quantity.



If I do allow additions I can get the totals to update but I expose the application to the possibility of a User adding an unwanted record or having Access display one of its Error Dialogs that only developers can understand.

Seems to me I've been fighting this problem forever and I would like to get it finally resolved.

Appreciate any assistance.

[boblarson]

What you need to do is to force a save. Depending on what you need as being required, you could just add this code to each control's after update event:

If Me.Dirty Then Me.Dirty = False

[bginhb]

Thanks Bob, that solved my problem.