Me.Visible=False not working

[jsic1210]

Okay, this one is driving me crazy. I'm trying to open a report with pop-up form. When the report opens, I want the form to stay loaded, but hidden. I'm using Me.Visible = False, but it's not working. Here is my code:

On Error GoTo SubError

'Open Report
    DoCmd.OpenReport "rptCPUWeeklySummary", acViewPreview, , "Year([Month Ending Date]) > " _
        & Year(Me.txtMonthEnding) - 2

SubExit:
    Me.Visible = False
    Exit Sub
SubError:
    MsgBox Error$
    GoTo SubExit

 

[EternalMyrtle]

Did you try referring to the form (i.e. Forms!"FormName".Visible=False) instead of using Me?

 

[MarkK]

Where is this code? "Me" refers to the class in which code is currently running which in this case is not the same object as the form you just opened using DoCmd.

Check out the acHidden WindowMode parameter of DoCmd.OpenForm(), which does exactly what you'd think . . .

DoCmd.OpenForm "SomeForm", , , , , acHidden

 

[jsic1210]

Yes, I tried that, but it doesn't work either.

 

[jsic1210]

Lagbolt,
I see what you're saying, but it's the pop-up I want to be invisible, not the report that I just opened.

 

[EternalMyrtle]

Is the pop-up programmed to open automatically when the report is opened or is it already open when the code to open the report is executed?

You could close the pop-up and reopen it as hidden. Seems roundabout but would prob work.