need to update "main" form from "sub" form

[dennisr]

I have a continous form with the displayed row collected from the union of three queries. On each row there is a control to open an approprate form (not subforms) for editing the row based on its source. This all works well except for reflecting the change on the calling ("main") form. I can't get the main form to display the change until it is closed and reopened. 1) How can I refresh or requery the main form? or 2) I can put a control button on the main form that will cause the change to appear...is there a way to have the code call that control event? Thanks. I find this forum very helpful.

 

[Trevor G]

I have a continous form with the displayed row collected from the union of three queries. On each row there is a control to open an approprate form (not subforms) for editing the row based on its source. This all works well except for reflecting the change on the calling ("main") form. I can't get the main form to display the change until it is closed and reopened. 1) How can I refresh or requery the main form? or 2) I can put a control button on the main form that will cause the change to appear...is there a way to have the code call that control event? Thanks. I find this forum very helpful.

Have you tried adding the requery behind the command button. Try something like this

DoCmd.Save
Forms![MainForm]![subform control name Name].Form.Requery

 

[dennisr]

Trevor, Thanks that worked.

 

[Trevor G]

Pleased to read you have a solution.