Results 1 to 4 of 4
  1. #1
    McArthurGDM is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    215

    Automatically designate any subform on a form to not visible?

    Hi,

    I have a main form and I would like to set a button on the page that will automatically close out any subform on the form. I could do this with VBA, but I will have many subforms on this page and many different scenarios in which one form is closed and one opened.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    me.sub.visible=false

  3. #3
    McArthurGDM is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    215
    Oh, nice. so that just turns off any subform huh?

  4. #4
    McArthurGDM is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    215
    Actually. I meant a command that will turn off all subforms without specifying the name.

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

Similar Threads

  1. Replies: 4
    Last Post: 11-04-2014, 07:35 PM
  2. Replies: 3
    Last Post: 06-10-2014, 03:36 PM
  3. Replies: 3
    Last Post: 03-29-2012, 12:40 PM
  4. Replies: 3
    Last Post: 03-23-2012, 11:21 AM
  5. Replies: 2
    Last Post: 01-06-2011, 04:38 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