Linked Report in Background 1

[bradleyhorn]

Hi All,

I have curious problem. I have inserted a hyperlink inside a form which calls a report. When the report is generated it remains in the background (behind the calling form.) How do I bring the report to appear in the forground, in front of the calling form? I looked at all the characteristics in the "form Properties" and nothing seem to apply to my problem. Happy for any help.

Bradley

 

[RoyVidar]

Guessing the form is either modal/popup, or opened with the acDialog arguement. What I do, is hide the form while the report is open, then make it visible again when the form closes. I don't use those hyperlink thingies, but suppose then you don't have any form event calling the report? Then perhaps in the on open event of the report

[tt]forms("yourform").visible=false[/tt]

and in the on close event of the report

[tt]forms("yourform").visible=true[/tt]

Roy-Vidar

 

[bradleyhorn]

Roy-Vidar,

Thanks for the tip. I may follow your advice and do away with the Hyperlink. It may be a more professional presentation to give them some sort of menu option or pull down where they can open their report. I believe the sofware package I am working on has a place for users to access reports written for them.

Thanks again, Bradley

 

[RoyVidar]

Thanx - but please don't take it as a recommandation - I have no views on professionality of hyperlink vs form events. True, I don't like them, but I did not mean any of the above as a recommandation

Roy-Vidar

 

[bradleyhorn]

My wife (a software developer) also told me make it available elseware.

Bradley