maximize report while minimizing form

[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

 

[Evi]

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

 

[Ofer Cohen]

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

 

[Ra]

Works great !!! Thank you so much,

Ra

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

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