keep focus (not)

[piet123]

please help,

i have mainfrm with cmdbutton.
on click cmdbutton: opens pop-up (modal) frm.

in the popup frm is cmdbutton to printpreview report. (rep based on query)

problem: when report opens, the popup frm stays on top of report (has focus ?) this i don't want.

so in vba i changed visible to (=false) for popup frm but when i close the report i want the popup frm back onscreen again ! HOW ?

thanks,
Piet.

 

[Mile-O]

Forms("MyForm").Visible = True