Report Previews behind Switchboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
..
 
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.
 
Back
Top