Pop-Up Reports

[andy_dyer]

Hi,

I have my whole database window hidden from my users view...

All my forms are of the pop-up variety...

I wish to preview a report on a click of a btton of one of these forms but when I do it opens behind the pop-up form...

Is there a way of getting this to happen??

 

[Rich]

Toggle the Visible property of the Forms

 

[andy_dyer]

I used this to make the form visible and not when the report opens and closes...

Because the database window in hidden then the report opens but is instantly minimised I have added a line of docmd.maximise after the make visible command but to no avail...

When I then manually maximise the report the access window reppears behind it which is not what i wanted.

Any ideas?

 

[Rich]

Therein lies the problem with hiding the application window.
You could of course format forms to look like Reports

 

[andy_dyer]

It was purely a nice to have that I found in an example...

Obviously they were not trying to hide the window so it worked for them, and I was trying to get it to work in mine...

Nevermind, thanks for your help tho!!

 

[=TB=]

Get the button to close the form when the report opens and then get the report to re-open the form on its close event, or vise-versa.

 

[IMO]

Place the report on a popup form, like you did here

IMO