Solved

Want Access Report to show on top of popup form

Posted on 2007-11-15
2
555 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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

829 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