[AccessD] Reports On top

Mike,

This is something to try:

When you need to open the report, first save the data, then close the form,
then open the report.  

	Private Sub cmdOpenReport_Click()

		DoCmd.RunCommand accmdSaveRecord
		DoCmd.Close acForm, "frmMyForm"
		DoCmd.OpenReport "rptMyReport"

	End Sub

HTH,
Dan Waters

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gowey Mike W
Sent: Monday, June 07, 2004 11:52 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Reports On top

 
Hi everyone,

I currently am working on a database in which I have the input form come
up as a popup for that it displays on the entire screen.  Now I need to
know if there is a way for me to view a report by pressing a button on
the form.  Currently it will not show the report because the input form
is on top.  Can I make the report open up in a popup type of way so that
the report is on top and viewable until closed.

I hope that makes sense.  Any help would be greatly appreciated.


Mike Gowey  MCSA, A+, LME
Team Leader - SRCI
Information Systems & Services Division
Technical Support Analyst


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com