Bring minimized form back in focus

gold007eye

Registered User.
Local time
Today, 15:28
Joined
May 11, 2005
Messages
260
Does anyone know what code I can use to bring focus back to a form that has been minimized?

Basically I have a form "Provider Letters" that is open. There is a button (preview) that you click to preview the letter in a Report format. When you click the button it minimizes the "Provider Letters" form and opens the Report in a print preview.

What I need to do is have it so that when you close the print preview it will bring the "Provider Letters" form back from it's minimized state. I had thought of doing maximize, but I don't want the form across the whole screenl; I just want to restore the form to the same state it was before it was minimized.
 
I tried that and it restored the window, but the form is still minimized. That part of code did help part of the problem though :)
 
how about just making the form.visible false/true instead?
 
I got it figured out ;) I needed to set the focus to the form 1st and then DoCmd.Restore. Thanks for the help everyone.
 

Users who are viewing this thread

Back
Top Bottom