Results 1 to 3 of 3
  1. #1
    BrockWade is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Dec 2013
    Posts
    63

    setting control = allowedits = true on subfrom from mainform

    I am trying to set a checkbox on my subform to allowedits=true by using a button on my main form. I've tried this but it does not work:

    Forms!reviewBilling!reviewBillingSub.Form.Controls .cbxAudited.AllowEdits = True

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    AllowEdits is a property of form. Remove reference to the combobox. Then no controls on the form will be editable.

    Really should use textbox and combobox Conditional Formatting if you want to just disable the one control.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    If you just want to control a single Control, in the OnCurrent event of the Form the Subform is based on, set the Locked property of the Checkbox to True:
    Code:
    Private Sub Form_Current()
     Me.cbxAudited.Locked = True
    End Sub

    Then set it to False with your Command Button

    Linq ;0)>

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

Similar Threads

  1. Setting Focus to subform from mainform
    By EddieN1 in forum Programming
    Replies: 3
    Last Post: 05-17-2015, 07:12 AM
  2. Replies: 7
    Last Post: 03-21-2014, 05:52 PM
  3. Checkbox in mainform to control subform
    By revned12 in forum Forms
    Replies: 3
    Last Post: 09-09-2012, 02:32 AM
  4. Setting AllowZeroLength to True
    By AlexisW in forum Programming
    Replies: 4
    Last Post: 05-28-2012, 01:05 PM
  5. Replies: 3
    Last Post: 06-20-2011, 09:30 AM

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