Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to secure form?

Status
Not open for further replies.

rafal444

Programmer
Aug 11, 2006
74
US
I want some fields accessible for some users only?
 
Load the form with those fields disabled in the Form_Load event:

Me.control.Enabled = False

Have an unbound control for users to enter a password. Check the password against a password held in a table. Then enable those fields if the password is correct

Me.control.Enabled = True

Ensure that the Form_Current event also disables the fields so that the fields are disabled when going from record to record.

Nigel.
 
a better way would be to enable the fields during the form load event based on the users ID

"My God! It's full of stars...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top