Changing Window States of Reports/Forms

[FireGeek]

I have used VBA to code the opening of a report as follows:

stDocName = "WarrantyListUnitSpecific"
DoCmd.OpenReport stDocName, acPreview, , "UnitType = '" & uType & "'"
DoCmd.Maximize
Form_frmUnitTypeSelection.SetFocus
DoCmd.Close

The DoCmd.Maximize maximizes not only the Report but also the
Switchboard with the Switchboard on top. I would like the Report on
top. Also, when the user closes the report, I want the focus to be
back on the Switchboard.

I have tried DoCmd.Restore in the Close event of the Report without
success.

Can anyone assist?

Tammy
MY****************@wi.rr.com (remove MYEMAILIS and the 822 to get my
actual address). THANKS!!!

[Barry Wright]

Hi Tammy,

Remove these lines from the open report procedure.
DoCmd.Maximize
Form_frmUnitTypeSelection.SetFocus
DoCmd.Close

Put the
DoCmd.Maximize
on the open event of your report and
DoCmd.Restore
on the close event of your report.

Your report will open full screen on top of everything and when you close it
the
DoCmd.Restore
will make your switchboard the normal size.

Regards,
Barry

"FireGeek" <fi*********@hotmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

I have used VBA to code the opening of a report as follows:

stDocName = "WarrantyListUnitSpecific"
DoCmd.OpenReport stDocName, acPreview, , "UnitType = '" & uType & "'"
DoCmd.Maximize
Form_frmUnitTypeSelection.SetFocus
DoCmd.Close

The DoCmd.Maximize maximizes not only the Report but also the
Switchboard with the Switchboard on top. I would like the Report on
top. Also, when the user closes the report, I want the focus to be
back on the Switchboard.

I have tried DoCmd.Restore in the Close event of the Report without
success.

Can anyone assist?

Tammy
MY****************@wi.rr.com (remove MYEMAILIS and the 822 to get my
actual address). THANKS!!!