Updating a field

  • Thread starter Thread starter Gary Nelson
  • Start date Start date
G

Gary Nelson

In Access2000, I have a field that I am trying to update the date in, but I
receive a message on the bottom of the form in data view which states that
the recordset is not updateable. The field is DaysAdded. For example, if
the number of days is currently at zero, and the user wants to add seven
days, they would enter the number seven. What are the possibilites that
would cause this not to update?

I have chacked for a unique table in the form, and checked the locked field
is NO in the fields properties. Any other thoughts?

Thanks in advance for your help.
Gary
 
Do you have a specific/unique query behind the form? I
have found this same type of problem when I have a more
involved query. It is not the table, field, or the form,
rather just the way Access handles the recordset the query
made.
 
Back
Top