Unchangeable fields in my table? (1 Viewer)

carrybag93

Registered User.
Local time
Today, 18:04
Joined
May 24, 2012
Messages
73
I cannot change the value in one of my fields in my Customers table. Is there some function that locks tables that I am unaware of (I am unaware of a lot :p)
 

MSAccessRookie

AWF VIP
Local time
Today, 04:04
Joined
May 2, 2008
Messages
3,428
The most likely possibility is that this field is defined as AutoNumber, and as such, cannot have its value updated or changed. Look in the Design View for the Table to determine this.

Another possibility (if you are using a Form to update the Field), is that the Form Locking Property for the Control related to the Field has been turned on.
 
Last edited:

carrybag93

Registered User.
Local time
Today, 18:04
Joined
May 24, 2012
Messages
73
Thanks, changing it in the form worked. What's the Form Locking Property? Is that in the property panel?
 

Users who are viewing this thread

Top Bottom