Cannot update field

S

scottm

I made a change to something ... somewhere ... sometime
and now I can't change the data in my fields. What flag
did I turn on?
 
S

scott

UPDATE: Could this have anything to do with the fact that
I can't add a new record either?
 
V

Van T. Dinh

Where are you trying to add / edit data?

DatasheetView of Table / Query? Form?
 
G

Guest

Trying to do it from a form.

I verified the "Data Entry" property is set to "Yes".

I'm lost.
 
V

Van T. Dinh

Got nothing to do with "Data Entry".

1. Check the Form's RecordSource. If it is a Query / SQL String, it may
not be updateable. Open the Query / SQL String by itselft, i.e. not through
the Form and see if you can update the data in the DatasheetView of the
Query. The Query may not be updateable and therefore the data on the Form
is not updateable.

If this is the case, check Access Help on "Updatable Query".

2. If the Query is updateable, check the Form's AllowAdditions and
AllowEdits Property.
 
Top