Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Want Access Report to show on top of popup form

Posted on 2007-11-15
2
Medium Priority
?
577 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 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

564 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