Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002

    Unanswered: Hide / Unhide "tabs" on a "tab" form


    I have created a "Tab" form. There is a subform on each tab related to a main table.

    Some of the tabs will only display info occassionally, so I'm wondering if there if a way to hide/unhide tab(s) depending on if they are displaying any info or not?

    Thanks in advance.



  2. #2
    Join Date
    Dec 2001
    You can set the tab control page visible property to "False" to hide the tab.

    To check to see if your subform has any data, you can count the records in the subform recordset clone like so:

    If Forms![MyParentFormName]![MySubformControlName].Form.RecordsetClone.RecordCount = 0 Then

    If there are 0 records, then nothing has been entered in the subform.

    Hope this helps,
    Peter De Baets
    Peter's Software - Microsoft Access Tools for Developers

Posting Permissions

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