Conditional Refresh

[Dazzy]

Hey All

I have two ways to enter work placements for students, I need to refresh a subform on one form while closing another.

The issue here is the form with the subform may not be open as mentioned above.

So is it possible on closing one form to refresh a subform only if it's parent form is currently open?

Thanks

Gary

 

[pr2-eugin]

I normally use the following to see if it is loaded.

If CurrentProject.AllForms("yourFormName").IsLoaded Then _
    MsgBox "The Form yourFormName is open !", vbInformation