Refresh multiple subforms at same time?

[mbannen]

from a main form (form_main) I open another form (form_not_main). I modify data in frm_not_main and close it. I then want to refresh multiple subforms on frm_main (the subforms calculate values based on data modified in form_not_main.

Tried a whole bunch of refresh things on every event that made sense, and can't get it to work for all the subforms.

Help greatly appreciated.

 

[john2thompson]

I suggest, instead of Refreshing the subform, try

<formname>.<subformname>.Requery
when you have updated information in frm_not_main

i seem to remember that this reloads the information in the subform, so if the data going into the subform has changed, the results should also be displayed.

hope this helps