Hiding form when opening it

  • Thread starter Thread starter B.
  • Start date Start date
B

B.

I want to hide form as soon as it is opened and that user don't notice form
opening.
I have function that hide it when I run it manually but don't know from what
event to call it.
I tried with On Load and On Activate but it seems that on those events form
still has not get visible=true.
So Q: is how to call procedure/function to change form.visible=false

In addition I want to have form that will call procedure every 5 minutes.
If you know some better method please advise.

Thanks in advance

B.
 
Put in Open event of form:
Me.Visible = False

To call a procedure every 5 minutes use the Timer and Timer Interval events
(see help).

ed
 
I want to hide form as soon as it is opened and that user don't notice form
opening.
I have function that hide it when I run it manually but don't know from what
event to call it.
I tried with On Load and On Activate but it seems that on those events form
still has not get visible=true.
So Q: is how to call procedure/function to change form.visible=false
Click to expand...

Are you opening the form using the "OpenForm" method? You can open a form
already hidden using this syntax:

DoCmd.OpenForm "MyFormName", , , , , acHidden

It appears that Ed has already covered your second question.
 
Back
Top