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?
 
Where are you trying to add / edit data?

DatasheetView of Table / Query? Form?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP! I can't make changes to my DB 3
Access How to remove a non-existent field from a form's Field List 0
Excel Help to copy information from one row at a time to another sheet 1
How to subtract a number from a Mergefield? 0
Google (Chrome) can be annoying 4
Update fields only after changes 2
set flag value if any fields in record change 3
Combo Box Visability Issue 1

Back
Top