Report Previews behind Switchboard

[Guest]

sI'm working in Access 2000. I recently created a parameter selection dialog
form that open via the swtchboard. Everything works fine except ... When I
set the dialog box to close after the report is previewed with DoCmd.Close
acForm ... the report will preview behind the switchboard. If I do not
program the dialog box to close, then the report previews on top with a
layering of SB with Dialog Box over the SB and the preview report over the
dialog box. With this, after I close the preview, I need to close the dialog
box manually. Not a major problem, but is annoying and probally will turn out
to be a real problem down the road - somewhere. This is the only dialog box
that I'm having trouble with. All others I created some time ago close and
the report previews on top of the SB. I am a rookie on this. What am I doing
wrong? What code am I forgetting to write? Please help. Thanks

 

[Guest]

Change the setting of your report to [popup] this just might do the trick..

 

[John Spencer]

Try closing the dialog box from the report's close event. That may be all
you need to do.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Hey Thanks. The pop up setting is correct, checked it again anyway. The close
form from the report worked fine. Just a note, last night I re-created the
dialog box form and it worked fine. When I did the form originally, I did a
copy and paste from another. So, somewhere along the line something went
wrong. Still don't know why, but the problem was corrected. Thanks again for
your help.