modal question

[Michael]

I have a form in which the user can click "reports"
button and get a popup form that is modal. On this popup
form you can do a report on an employee. Problem is, when
you click on "generate report" the report is behind my
popup form. I've tried slecting yes, modal, on my report
too, but it still does it.

Help!

 

[berk]

Try this

(Your Code)
docmd.OpenReport "whatever", acViewPreview
forms![YourFormName].visible = False

This will hide the form that has the button to view the
report. Then in the report, on the OnClose event, make the
form visible again like this:

forms![YourFormName].visible = True