Hiding form when opening it

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.
 
E

Ed

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
 
B

Bruce M. Thompson

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top