Solved

Want Access Report to show on top of popup form

Posted on 2007-11-15
2
550 Views
Last Modified: 2013-11-28
I have a popup form where users have the option of clicking a cmd that brings up a related report. unfortunately, the report shows up under the popup and it is necessary to close the popup to see the report.

What I would like to happen is:
1) users click cmd, report appears on top of the popup
2) users views report, closes
3) popup is visible again

I don't think that I can have the popup close and reopen as the popup is based on some criteria on another frm that would probably be complicated to recreate if it had to be opened again.

Ideas?

mama
0
Comment
Question by:mamadouthiam
2 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 20291592

when you open the report, hide the popup form

docmd.openreport "x"
me.visible=false


in the close event of the report make the popup form visible

private sub report_close()
forms.nameofform.visible=true
end sub
0
 

Author Comment

by:mamadouthiam
ID: 20291632
capricorn1,


Excellent - thanks.

mama
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now