Problem with OnClose event 1

[lifter10]

I have a form that allows the user to select certain reports. When the user is done viewing the report, I would like that form to open up again. Problem is, when I use the OnClose event in the report to open up the form, the report stays open. I suppose this is fine, but when I try to run that same report again, it closes out my form and doesn't open the report.

How do I get the flow between the report and forms down?

Thanks in advance,

Chris

 

[RoyVidar]

What I sometimes do, is not close the form, but set its visible property to false. Then in the on close event of the report, set it to true again:

[tt]me.visible=false
docmd.openreport "myrpt"...[/tt]

then in the report:
[tt]forms("name of the form").visible=true[/tt]

I then often include some test whether the form is open or not (IsLoaded function from the NorthWind sample database would surely do)

Roy-Vidar

 

[lifter10]

Oh that worked well! Thanks for the tip.