Security/Editing fields

[Guest]

Hello,

I have a form that has 10 fields made up of Text and CBO's. How can I make
it where user are only allowed to edit 4 fields on the form for each record
but management can edit in all 10 fields? Is there a way to lock the fields I
don't want edited and have management click a button to prompt a pop up for a
password to open the fields or is there a easier way? Please note, I am a
novice so you will need to walk me through and simplify your response. your
help would be most appreciated.

Thank you in advance!

 

[Eric D via AccessMonster.com]

Yes, you can do exactly as you outline.
You can set the 4 fields you mention to Enabled=True, Locked=No and the
others to Enabled=False, Locked=Yes.
Create a button that prompts for a password. If entered correctly, code
changes the Enabled=False to Enabled=True and Locked=Yes to Locked=No.

This requires a hardcoded password and is not the best way of accomplishing
what you want, but it meets your criteria and would be the simplest to
perform. Note that anyone who has the know how could bypass this and anytime
a manager doesn't want to take on this task, if they give the password to
someone else, you security is bypassed.

If your users are required to log on and enter a password now, that would be
the better way to go... but you don't indicate that in your request.