Cannot update field

  • Thread starter Thread starter scottm
  • Start date Start date
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?
 
UPDATE: Could this have anything to do with the fact that
I can't add a new record either?
 
Trying to do it from a form.

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

I'm lost.
 
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.
 
Back
Top