subform not allowing additions

[Pat]

Access 2003.
I have a form/subform where the subform is not allowing additions. There is no blank record t the end of the subform.
The DataEntry is False
AllowAdditions is True

What other condition(s) do I need to look at?

It's ok the query behind the subform is not updateable. I believe it works with an Access BE but it is not on SQL Server BE.

[Mark L]

If the query is not updateable, you can't add records.

[Pat]

The query was updateable with the Access BE, but not with a SQL Server BE, at least that is what it appears to be.

See See this post for the solution.

[kwvh]

Does the table being updated have a unique key field? I ran across a similar situation that was related to no primary key in the SQL table.

Ken