Copy a form and make it a popup (1 Viewer)

[MajP]

If you close the form and pop open, you may want to have it return to the same location it was in.
As far I know the only way to move document tabs is to open them in the correct order. So prior to opening the popup read the form's collection which will have the forms in the order as opened. Save that list somewhere like a collection. Pop up the form and close the tabbed version. When you close the pop up then close all the forms and reopen in the original order. This will give more of an illusion of popping open and then returning.

 

[mreinsmith]

I know it's been a while so thanks for your help

STILL trying to get back to it

 

[CJ_London]

a technique I have used in the past is to have a popup container form with nothing in it except a subform control. The vba opens it then sets the source object to the required form - may also need to set filters, resize the form/subform as required, perhaps also set some other properties such as editing not allowed - these may need to be passed to the popup form as an open arg to be referenced in the form open/load events