Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Unanswered: Unlocking controls on Subform

    I am trying to use the following code to make unlock field on a form. It does not seem to unlock the fields on the forms subform. Is this true and if so is there a means to modify this code to change the subforms controls? Thanks

    For Each ctl In Controls
    If TypeOf ctl Is TextBox Or TypeOf ctl Is ComboBox Then
    ctl.Locked = False
    End If
    Next ctl

  2. #2
    Join Date
    Nov 2005
    Posts
    113
    I think you may do like this:

    For Each ctl In Form_subformsName.Controls
    If TypeOf ctl Is TextBox Or TypeOf ctl Is ComboBox Then
    ctl.Locked = False
    End If
    Next ctl

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •