Report Opens in Backround

[rmcompute]

I set up a form which has a control to open another form. The second form
has a control to open a report. When the report opens, it remains behind
both forms. Is there a way to open the report in the foreground without
closing either form ?

 

[Rob Parker]

I suspect that your forms are opened in dialog mode; that will keep them
displayed on the top of anything else. You can either change the mode of
the forms (which may affect your user interface in other ways - you'll need
to decide whether that's acceptable), or hide the forms before opening the
report, and then unhide them in the report's close event.

To hide/unhide each form, all you need is a single line of code:
Forms("NameOfForm").Visible = False 'to hide, or True to unhide

HTH,

Rob

 

[tina]

sounds like the two forms' Popup property is set to Yes. you could either
set the Popup properties to No in the procedure that opens the report, and
then reset to Yes in the report's Close event procedure - or set the forms'
Visible properties to No, and then back to Yes.

hth

 

[rmcompute]

I used Forms("NameOfForm").Visible = False and it worked.
Thank you.

 

[rmcompute]

I used Forms("NameOfForm").Visible = False and it worked.
Thank you.