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.
subform not allowing additions
-
- 3StarLounger
- Posts: 331
- Joined: 11 Feb 2010, 03:55
- Location: Land O Lakes, FL
Re: subform not allowing additions
If the query is not updateable, you can't add records.
Mark Liquorman
Land O Lakes, FL
see my website http://www.liquorman.net for Access Tips and Tricks, and for my Liquorman Utilities.
Land O Lakes, FL
see my website http://www.liquorman.net for Access Tips and Tricks, and for my Liquorman Utilities.
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: subform not allowing additions
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.
See See this post for the solution.
Last edited by Pat on 29 Aug 2010, 00:31, edited 2 times in total.
-
- 3StarLounger
- Posts: 308
- Joined: 24 Feb 2010, 13:41
Re: subform not allowing additions
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
Ken