Updating form after updating and closing a popup window

[Historypaul]

My main form has a list of all records in a continuous form format. When you click on one of them, the record is opened up in a popup window where you can edit the details. When I close the popup window, I want the original form to be updated with the info updated in the popup window.



Now here's the kinda tricky part. I don't want to hard code the form name because the main form may not always be a subform of the same parent. I assume the easiest way would be to pass on the name of the form in open arguments as a string variable, then call for a refresh of that form on the "after update" event of the popup, or on the "Close" event. BUT... Has anybody designed a function that will return the full path name of the form object dynamically so I can pass it on as an open argument?

A function like this seems like it would be a useful tool. I'm just hoping I'm not the one that has to write it.

[June7]

Open the second form with acDialog parameter. This suspends code execution on the calling form until the second form closes. The next line of code can be:

Me.Requery

Don't understand "the main form may not always be a subform of the same parent" - how can a main form be a subform?

[Historypaul]

Wow... So simple. So perfect. THANK YOU! Works great!