Solved

Want Access Report to show on top of popup form

Posted on 2007-11-15
2
544 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
Comment Utility

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
Comment Utility
capricorn1,


Excellent - thanks.

mama
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

772 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

11 Experts available now in Live!

Get 1:1 Help Now