UserLogOff

[soundsfishy]

Ive split my DB and now Im trying to add a Logoff function that I got from RogerAccessLibrary.

I have a logon form and I want to add the code on this form. The form checks a field every 5 minutes and lauches a message form.

I need to have my LogOn form as hidden after the user enters the password to open the data entry form.

How I use code to hide a form.?

 

[IMO]

To open the form hidden...

         DoCmd.OpenForm "YourForm", acNormal, "", "", , acHidden

to hide the form after an event (LogOn)...

         Me.Form.Visible = False

HTH
IMO

 

[Mile-O]

Me.Form.Visible = False

Or, more simply:

Me.Visible = False


Another route you may want to take is if the form you wish to hide is not the active form:

Forms("MyForm").Visible = False

or

Forms!MyForm.Visible = False

 

[soundsfishy]

Yep! that exactly what I want .

Thanks.