Minimized form opens

[Lambo]

When opening my report i minimize the report select form i have in place, this allows the user to browse the report on the screen and then when they close the report i have the report select form maximize on the screen again.
This has been working great and still works for all my other reports however for 1 particular report when the user browses to the second page the report select form pop open in front of the report.
This now happens everytime with this report but not with any others.
I've checked the code and all the reports minimize the report select screen using the same piece of code but withint this one report when the user clicks to view page 2 using the default buttons the report select screen pop up.

Its driving me mad, has anyone ever seen this before or got any ideas hwo to fix it???

 

[sahar2824]

hello

When opening my report i minimize the report select form i have in place, this allows the user to browse the report on the screen and then when they close the report i have the report select form maximize on the screen again.


please i want ur help how did u do this

sorry i cant help u

 

[Lambo]

The basics of it are below, firstly for opening the report and minimizing the report select screen i have the following code on the button to run the report;

Select Case Reports.Value
Case Is = 1

stDocName = "ReportName1"
DoCmd.OpenReport stDocName, acPreview

Case Is = 2

stDocName = "ReportName2"
DoCmd.OpenReport stDocName, acPreview

End Select

DoCmd.SelectObject acForm, "frmReports"
DoCmd.Minimize

The last part of the code minimizes the screen for the report select.

Then in the On close event of the report i have

DoCmd.SelectObject acForm, "frmReports"
DoCmd.Restore

Hopefully that helps you out, Good luck.

Anyone else any ideas for my issue above???

 

[sahar2824]

the code help me alot

butwhen i make the code in navigation form does not run and i cant see no report no main form

also u should know that i made aform behinde to make my project not navigation pane not access toolbars

i hope u undrestand me

 

[Lambo]

Create a black form and call it "frmReports"

Put a button on the form and in the on click event for the button paste the following code;

stDocName = "ReportName1"
DoCmd.OpenReport stDocName, acPreview

Remember and change ReportName1 to the name of your report.

Finally in the On Close event of your report put;

DoCmd.SelectObject acForm, "frmReports"
DoCmd.Restore

If you are still having problems create your own thread and send me a link and i will have a look so as not to clutter this with posts not relevant to my issue.