var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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,