Having trouble previewing a report on top of a pop up form! 1

[jimtmelb1]

I have created a form in Access 2000. It's a pop up form. When the user opens this form they have an option to preview a report. Instead of the report being in focus it is behid this pop up form. I can't close the form when the preview button is hit because the report requires data from my form.
Is there another way that I can bring the preview of the report to the front and have the pop up form behind it.

If anyone can show me how I would be very appreciative.

Thanks
Jim

 

[TheAceMan1]

How are ya jimtmelb1 . . . . .

In the [purple]Open[/purple] event of the Report, [blue]hide[/blue] the form with:

[blue]   Forms!PopUpFormName.Visible = False[/blue]

In the [purple]Close[/purple] event of the Report, [blue]show[/blue] the form:

[blue]   Forms!PopUpFormName.Visible = True[/blue]

See Ya! . . . . . .