I know I can do this in a form. It's in the table that I want the field to be
readonly. Don't other people need this capability also?

Do I need to force my users to go through a menu and a form? How do I
prevent them from just opening the table and changing this field? Maybe even
by accident.

By the way, I'm using Access 2007 and DAO

"bhicks11 via AccessMonster.com" wrote:

Change the LOCKED property to YES. You can change it to NO in VBA if you
need to make changes and then change it back so users can't. You will find
the property in the DATA tab of the property sheet.

Bonnie
http://www.dataplus-svc.com

MarianneZ wrote:
In my table I have 2 fields that I do not want users to change. It's okay if
Vba code changes the values, but not a user directly. Is there any way to
enforce this?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200902/1