Invisible Form - part 2 1

[Alcar]

Again I didn't find any solution to make a form invisible.
The method .Visible = false doesn't work
not even with a form.refresh after it. I can still see it.
Any ideas???

Thanks in advance!
Alcar

 

[nickjar2]

Try me.visible = false

or if you are referencing form1 from form2 and you want form1 to become hidden try:

forms!form1.visible = false

Nick

 

[jebry]

Hi!

You shouldn't need to use it but form refresh isn't what you are looking for, you want repaint. Refresh requeries the form and repaint reloads the screen.

hth
Jeff Bridgham

 

[Alcar]

Repaint doesn't help either...

this is the code of the invisible form

Private Sub Form_Load()

DoCmd.OpenForm "Status"
Me.Visible = False
Me.Repaint

End Sub

 

[nickjar2]

I am not too sure I understand what you are doing. What about docmd.openForm "formName",,,,,acHidden

Not sure whether the Constant is acHidden or if it after the correct comma.

Nick

 

[jebry]

Hi!

The only other thing I can think of is to switch the Me.Visible = False and the DoCmd.OpenForm "Status" lines. BTW, is Status a modal form?

hth
Jeff Bridgham

 

[Alcar]

Great job nick!!

That totally solved my problems.. with this code

DoCmd.OpenForm "Invisible", , , , , acHidden

the status form will open the invisible one in the load event. the if I close the statu form everything is fine. Now I can catch the close event of the entire project with this invisible form!!!

Thank you again both of you
Alcar