Allow Additions property not working

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • blakerrr
    New Member
    • Oct 2007
    • 27

    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.
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    Originally posted by blakerrr
    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.

    Comment

    • missinglinq
      Recognized Expert Specialist
      • Nov 2006
      • 3533

      #3
      And don't forget, if AllowEdits is set to NO for the main form, the subform will also be non-editable!

      Linq ;0)>

      Comment

      Working...