maximize report while minimizing form

  • Thread starter Thread starter Ra
  • Start date Start date
R

Ra

Maximize report while minimizing form

Could someone give me an idea on how to maximize the report while the form
minimizes?

Pop up and Modal features have to be on “No†in the report properties.

Any help is greatly appreciated.

Ra
 
The 'while' throws me. If I've misunderstood, please say.

If you are opening the report with a button on the form then the button will
say in its code
DoCmd.Minimize
In the report's On Open Event you can put
DoCmd.Maximize


Evi
 
Instead, you can set the visible property of the form to no, and then set it
back to yes when you close the report

On the event that open the report

Docmd.OpenReport .....
Me.Visible = False

On the close event of the report, add the code
Forms![Form Name].Visible = True

change the Form Name to your form name
 
Works great !!! Thank you so much,

Ra

Ofer Cohen said:
Instead, you can set the visible property of the form to no, and then set it
back to yes when you close the report

On the event that open the report

Docmd.OpenReport .....
Me.Visible = False

On the close event of the report, add the code
Forms![Form Name].Visible = True

change the Form Name to your form name

--
Good Luck
BS"D


Ra said:
Maximize report while minimizing form

Could someone give me an idea on how to maximize the report while the form
minimizes?

Pop up and Modal features have to be on “No†in the report properties.

Any help is greatly appreciated.

Ra
Click to expand...
Click to expand...
 
Back
Top