cleaning up functionality

[diversoln]

I've designed a db and have the basic functions working pretty well now and just want to clean up a few issues.

First, when the user clicks buttons to open new forms and navigates thru the screens to use the forms and reports, I'd like only the active window to show up in the tray at the bottom of the screen. That way if the user switches to another application and then back to Access, there will be no doubt that the correct window will be selected and open for use. I've noticed as I use the db, several windows become open at once. What is the best way to set this up for forms and reports ?

Second, when escaping out of a report to return to the form from which it was initiated, the form window is no longer maximized. I've also noticed that this occurs when moving between forms in the db even though I have code associated with On Open to maximize each. What's the best way to make sure these windows remain maximized?

Thanks in advance for any help you can provide !

 

[diversoln]

Your solution to the first part of my question works GREAT !! Thanks!

I'm still struggling with the solution to the second part of the question.

I've looked at the code for the OpenReport Method/Action and still I'm not sure how to maximize the form window when I'm finished viewing the report using this code. My code associated with the button on my form currently looks like this:

Private Sub PVReport_Click()
On Error GoTo Err_PVReport_Click

Dim stDocName As String
stDocName = "ProcessVarianceReport"

DoCmd.OpenReport stDocName, acPreview
DoCmd.Maximize

Exit_PVReport_Click:
Exit Sub

Err_PVReport_Click:
MsgBox Err.Description
Resume Exit_PVReport_Click
End Sub


When I bring up the report by pressing the button associated with the above code, the report is maximized but when I press escape to return to the form, the form that was maximized is no longer maximized. Any ideas ?