Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2015
    Posts
    23

    Unanswered: How to Hide and display sub-form using a button

    Pls I have a form and a sub-form on the same page. I only want the sub-form to display and minimise when I click a button. Pls I need the vba code to do this. Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    In the butoons on click event

    Assume the subform is called mysubform
    Code:
    mysubform.visible = not mysubform.visible
    An alternative would be to toggle the enabled property.
    The vba above says set the visible property to the inverse of the current visible property
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2015
    Posts
    23
    Thanks, that worked perfectly.

Posting Permissions

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