Results 1 to 4 of 4
  1. #1
    Jackie is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2011
    Posts
    15

    AllowEdits in Subform

    Hi all

    I'm having a problem I can't seem to affect the AllowEdits control in my
    subform. I have a command button that when clicked changes the property of the main form to allow editing which works just fine. But I can seem to get it to work with my subform

    Code is:
    Private Sub Edit_Click()



    Me.AllowEdits = True
    Me.AllowDeletions = True
    Me.QuotationDetails.Form.AllowEdits = True
    Me.QuotationDetails.Form.AllowDeletions = True

    End Sub


    Any Ideas?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Offhand that looks okay. What's the record source of the subform? If it's a query, is the query read-only?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Jackie is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2011
    Posts
    15
    Hi yes it was set to read-only (I should have got that) working now thanks for the help

    cheers
    Jackie

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Happy to help Jackie.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Pass Subform filter to subform in report
    By camftm in forum Programming
    Replies: 16
    Last Post: 07-19-2011, 07:12 AM
  2. Form combo box not working with AllowEdits = False
    By jgelpi16 in forum Programming
    Replies: 3
    Last Post: 02-04-2011, 05:08 PM
  3. Write Code to Navigate from Subform to Subform
    By Swilliams987 in forum Programming
    Replies: 22
    Last Post: 02-04-2011, 11:30 AM
  4. Replies: 15
    Last Post: 11-09-2010, 04:27 PM
  5. Replies: 1
    Last Post: 12-10-2005, 04:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums