Logon to a form

[pbcharlie]

Is it possible to write a function that is called when a form is loaded to request a password from the tblpass and only allow the form to be opened if the password matches?

If so help to do this would be much appreciated
Thanks in advance
Charlie

 

[DJN]

Have a look at the Microsoft Knowledge base. There is a very good article on password protecting forms.

http://support.microsoft.com/default.aspx?scid=kb;en-us;179371