Report going behing modal forms, when opened.

[ahvc]

Greetings.

I have an issue with my first report for the application.

When I open Access, Form1 pops up. Then Clicking on a button, Form2 comes up. Clicking on another button, Form3 comes up. All these 3 forms have the modal and popup properety set to 'Yes'. Then I click on another button on the 3rd button, and I get my report, but the problem is the report is all the way in the back, behind Form1. Obviously, I would like it to display in front of form3. Ideally, I would think if Reports also had 'modal' and 'popup' property, then this situation should not have occured.

Can anyone pl tell me how I can avoid this situation.

Thank you really.
VC

 

[Sohaila Taravati]

You should toggle the forms visibility with code. Put this code behind the onclick event of your button
[Forms]![Main Form].Visible = False
[Reports]![Main Reportt].Visible = True