467,888 Members | 1,509 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,888 developers. It's quick & easy.

Allow Additions property not working

Hi All,

I have a subform, which needs to allow for additions. When I set the "Allow Additions" property to Yes, the form still doesn't allow me to add anything.

Am I missing something here???

Thanks.
Mar 20 '08 #1
  • viewed: 5360
Share:
2 Replies
ADezii
Expert 8TB
Hi All,

I have a subform, which needs to allow for additions. When I set the "Allow Additions" property to Yes, the form still doesn't allow me to add anything.

Am I missing something here???

Thanks.
There could be many reasons for this such as:
  1. The Record Source of the Sub-Form is not Updateable.
  2. The Recordset Type Property is set to Snapshot.
  3. The Form has a Filter applied (or is opened with a WhereCondition) that yields no Records.
  4. The Form is based on a Query where the criteria yield no records.
  5. The Form is based on a Table that has no records.
Mar 21 '08 #2
missinglinq
Expert 2GB
And don't forget, if AllowEdits is set to NO for the main form, the subform will also be non-editable!

Linq ;0)>
Mar 21 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

29 posts views Thread by C A Upsdell | last post: by
10 posts views Thread by Michel Rouzic | last post: by
reply views Thread by Scott_from_Carematic | last post: by
1 post views Thread by chris | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.