report opens.. but not to front

[kroenc17]

Hello all.. I've been working on a database that has a Form open ... "Home" .. at all times. Can't be closed. So far all the other forms and reports I've made have opened in a new tab at the top of the screen and when I open them they are sent to the front or they are put on top of the "Home" form ... for some reason I now have ONE report that opens itself in a new tab as they all do, but it puts itself behind the "Home" form, and I have to click on it's tab to bring it to the front.

How do I change this?

Edit: I should also note that a form is used to generate the report in question. An employee is selected and then a command button with an embedded macro is clicked. The Macro is:
OpenReport
Close

The first line opens the report, the second line closes the form.

Thanks

[weekend00]

put this after the code which open the report:

reports("report name").setfocus

[kroenc17]

If I remove the Close line from the macro, the Report opens on top of the "Home" form as I want it to, but the mediator form still remains open, as such: (see 1.jpg attached)

[kroenc17]

weekend: added this line to the bottom of my macro

Action: RunCode
Arguments: reports("Workload").setfocus

I get this error: Access can not find the field 'setfocus' referred to in your expression.

[kroenc17]

solved it myself in VB:
Set the command button to event procedure.. heres my code

Private Sub Command1_Click()
Me.Visible = False
DoCmd.OpenReport "Workload", acViewReport
DoCmd.Close acForm, "Staff Search"
End Sub

I had tried the event procedure approach but was using acViewNormal instead of Report and that was trying to print my report every time lol

[weekend00]

I am glad that you figured it out