How to force to update a control in a sub-form? 1

[sudakov]

Hello everyone,
I have a continuous sub-form within a form. The sub-form has a text-box control "TXB_AGGREGATE" that aggregates values (=SUM([FIELD1]) of a field in the sub-form.

If a user has not finished entering a new record in the sub-form (user does not move to a next record) the text-box control "TXB_AGGREGATE" is not updated with a value from the new record.

In many cases users do not move to a next record to save a new record in the sub-form. Instead they click on a button "BUTTON1" in the main-form. The button "BUTTON1" uses a value in the text-box control "TXB_AGGREGATE" in the sub-form which is not updated.

Does anybody know how to force to save a new record in the sub-form and to update the control "TXB_AGGREGATE" in the sub-form?

 

[TheAceMan1]

How are ya sudakov . . .

In your button code try:

[blue]   [[purple][b][i]YourSubformName[/i][/b][/purple]].Form.ReCalc[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[sudakov]

Hi TheAceMan1,

it works like a charm!
Thank you!