Rocky Smolin
rockysmolin at bchacc.com
Fri Dec 21 11:52:29 CST 2012
Fixed. The condition was - before running the report the program checked a condition and if it was true did some stuff and then called the Save Record subroutine. SO I just changed the call to the Save routing to DoCmd.RunCommand acCmdSaveRecord and it works. The stuff that's being checked in the save record routine is not necessary at this point. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee Sent: Friday, December 21, 2012 9:28 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Report not on top Make sure the calling form doesn't have its Border Style set to Dialog. On Thu, Dec 20, 2012 at 5:56 PM, Rocky Smolin <rockysmolin at bchacc.com> wrote: > Dear List: > > I have a report that is run in Preview mode from a calling form. > Under certain conditions, which I can replicate, the report opens in > preview but the calling form is on top of the report - that is, Window > 1 - db container, Window 2 - Main Menu, Window 3 - calling form, > Window 4 - report in Preview. > > If I run the report in preview the report seems not to run but if I > pull down the Window menu I see the report there as Window 4 and can > click on it and see it. > > Problem is 1) I don't know why that is happening, and 2) if I knew how > to force Window 4 to the top I'd just do that, but I don't. > > Is there some way to select the window you want on top? It may not > always be window 4 depending on how they get to the calling for. I'd > like to specify it by the report name if possible. > > MTIA -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com