Report is behind form!!!

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Hi,

I have a form use to print selected record. The form is opened as a dialog
so that this form stay on top of the other form. When I preview a report,
the report goes behind the form and user cannot see anything except the
margin of report. Is there a way to bring the report in front of the form
(that opened as dialog)?

SF
 
Hi,

I have a form use to print selected record. The form is opened as a dialog
so that this form stay on top of the other form. When I preview a report,
the report goes behind the form and user cannot see anything except the
margin of report. Is there a way to bring the report in front of the form
(that opened as dialog)?

SF
Click to expand...

If the form is opened in dialog it will remain on open and on top
until you either close the form or, usually, just make the form not
visible.
Add a command button to the form.
Code it's Click event:
Me.Visible = False

Then code the report's Close event
Forms!FormName.Visible = True

or if you are through with the form:
DoCmd.Close acForm "FormName"
 
Back
Top