I'm using a form with a multiple record type subform.
The heading of the subform contains a calculated field which is a percentage based upon a bound textbox value in the main form and one in the sub-form defined by a domain aggregate.
The mainform also contains a button that opens a form that permits the User to update underlying fields in the table bound to the main form thus changing the value in the displayed % field identified above.
Here's the problem ... when the fields in the update form's values are actually changed, upon close of the update form and return to the "calling" form the % field displays "#error" until the cursor is moved to another record in the sub-form then the field updates correctly.
This suggests to me that the problem is that the updated record has never been written and therefore no OnCurrent event was triggered. How can I force a record update from the update form or is there a way to trigger the needed event upon return to the "calling" form after updating?
Appreciate any assistance.
bginhb