report preview

[steve a]

hi.
I have a modal popup form, which has a comand button to preview a report,
howeevr the preview always sits behind everything....
Is there anyway i can get it to come to the front? so you can see it?
Thanks

 

[Jeff Boyce]

Steve

"Modal" means "keep on top". Try changing how that form displays
(de-modal-ize it).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[steve a]

Hi jeff.
I've made it so that the forms are now not modal, however th epreview is
still behind the popup's (there is 3 in total, one is maximised to full
screen, the others are still visible). ANy ideas? I was thinking maybe that
there would be some code to include in the preview command which would bring
it to front or select it (like ? setfocus?)
looking forward to your reply.
Thanks again
stev

 

[Jeff Boyce]

One ?what? is maximised, 3 ?what? in total? Forms? Reports? Preview or
previews?

When I use a form to gather criteria, then open a report (maximized) in
preview, it always comes to the front (i.e., hides the form).

Can you describe a bit more about what your design is doing that's
different?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[steve a]

Hi
Sorry reading the post back it was quite confusing!!

I have a series of forms, three in total, one of the forms is a
maximised popup which is unmoveable. The other two are just as normal
popup's. one to select the type of report, the other to input data into the
report from combo / text boxes.
on the last of these forms is a preview report command button. and the
preview opens behind all the other reports and isn't "active", the last form
remains active.

it would be good to maximise the preview how do i do this, the current code
i use for the preview button is:

Dim stDocName As String

stDocName = "rptptias"
DoCmd.OpenReport stDocName, acPreview


hope that clears things up a little....
thanks for your input jeff,
steve

 

[Jeff Boyce]

Rather than putting the "maximize" in the preview code, consider adding it
to the Report's OnOpen event.

Regards

Jeff Boyce
Microsoft Office/Access MVP