Form not allowing updates

[Arnold Klapheck]

when I try to update/edit in my form I get the message, "The recordset is not
updateteable"
Using Access 2007, on properties it says my recordsource is the correct
table, allow edits is set to yes, it is not locked.

I based the form off a query that pulls fields from three different tables
and it seems to post up right. I am thinking it is using the query as the
recordset hence it cannot update the table? Any Ideas how to fix this?

 

[Ken Snell \(MVP\)]

A three-table often is a nonupdatable query, so likely that is the problem
with your form. You can test this by opening that query in datasheet mode
and looking to see if the "new record" button (the one with the star on it)
is greyed out -- if it is, the query is nonupdatable.

Post the SQL statement of the query so that we can have more information.

 

[Golfinray]

Check and make sure your table and query are editable (they should have an
arrow and asterisk at the bottom.) If they don't you will probably need to
rebuild one or both. If your table and query are not editable, neither will
your forms be editable. Some types of queries, like union or crosstab are
never editable. If you have one of those you could try to take that query,
turn it into a select query and then try maketable.

 

[Linq Adams via AccessMonster.com]

Here's Allen Browne's article on why some queries are read-only:

http://allenbrowne.com/ser-61.html

 

[Arnold Klapheck]

It seems I made my main table uneditable, I don't remember when I did that
and I cant figure out how to make it editable, any suggestions?

 

[Golfinray]

Allen Browne has some good tips on tables that are not editable. Try
www.allenbrowne.com and check his Access tips. One thing to try first though,
is just to recreate the table, if possible. Also check help because I think
there is a good help article on what causes tables to be uneditable.