simple event question (i hope)

  • Thread starter Thread starter sargum
  • Start date Start date
S

sargum

Hi,

I have a button in a form, which if clicked, opens a report...

It does this just fine on the "on click" event, but displays the report
behind the form. How can I make the report show up in front of the
current form? Ideally, I would want it to show up in front of the form
(in a slightly smaller window).. I want to do this so that users don't
have to waste time finding the report...they end up having to minimize
the main form to obtain the report.

Thanks.
S
 
Hi,

I have a button in a form, which if clicked, opens a report...

It does this just fine on the "on click" event, but displays the report
behind the form. How can I make the report show up in front of the
current form? Ideally, I would want it to show up in front of the form
(in a slightly smaller window).. I want to do this so that users don't
have to waste time finding the report...they end up having to minimize
the main form to obtain the report.

Thanks.
S
Click to expand...

Put a line

Me.Visible = False

in the VBA code immediately after the OpenReport method call. You'll
probably want to also set the form visible in the Report's Close
event.

John W. Vinson[MVP]
 
A belated thanks to Barry and John...I didn't realize that setting
Popup to true would do the trick.

S
 
Back
Top