Reports behind forms

[ptiernan]

I hope someone can help me with this problem. In my access 97 DB I have a button on a form that has been maxinised. This button shall then produce a popup form to select certain critera. Upon pressing ok the form a report should be generated.

The report is generated but the problem is that the form that the original button is on appears in front of the report.

What I want to do is have the report in front of the form.

Can anyone help me.

Much Thanks
Paul Tiernan

 

[SpankYou]

hey,

in the report open function you could put,

formname.visible = false

and then in the report close function

formname.visible = true

Not a perfect soloution but should work,

hope this helps

Sam