Open report on Maximize form

[Fekri]

Hi,

I have a form which is opening in maximize and in form property I choose "Border style = none"
So form will fit to the monitor screen.
on this form I have button which will open the report.
But report will open on behind the form for this reson I have to close the form first to see the report on the behind.
I can also put in report on open event that first minimize my form then open but I want to do easier way.

Is there any body know????


Thanks for your helps
A.fekri

 

[THWatson]

A.Fekri
I can't quite figure out why your report is opening behind your form. That doesn't happen with anything that I have.

Are you certain there isn't some other command that is getting in the way and keeping the form in front of the report? Maybe a macro or something?

Tom

 

[RoyVidar]

I think the form might be is set to pop up, modal, or opened thru the acDialog arguement of the openform method of the docmd object.

What I do, is hide the form while the report is open (i e, in the code opening the report, place a Me.Visible=False), then in the on close event of the report, display the form again.

[tt]forms("name of form").visible=true[/tt]

- the latter would perhaps need a test if the form is open, for instance like the IsLoaded function from the Northwind sample database or Rohdems faq faq181-320.

Roy-Vidar