tabs

[Lauren B.]

I have a series of checkboxes located on one of three tabs on a form. One
particular checkbox is labelled "vendor involved." When the user clicks
this box, I want an additional fourth tab, labelled "vendor info" to appear.
This tab should only be visible if the "vendor involved" box is checked. Is
there a way to write the event procedure to open a tab?

Also, as a safety feature, if the "vendor involved" box is unchecked, will
the information entered under the "vendor info tab" be saved?

Thank you for any assistance!

 

[John Vinson]

I have a series of checkboxes located on one of three tabs on a form. One
particular checkbox is labelled "vendor involved." When the user clicks
this box, I want an additional fourth tab, labelled "vendor info" to appear.
This tab should only be visible if the "vendor involved" box is checked. Is
there a way to write the event procedure to open a tab?

Yes. Set the Visible property of the tab page to False in the Form's
Current event; then in *both* the Current event and the AfterUpdate
event of the combo box, set it to True:

Also, as a safety feature, if the "vendor involved" box is unchecked, will
the information entered under the "vendor info tab" be saved?

The information is not stored on the tab page or on the form. It's
stored in a Table; and once it's there, it makes no difference whether
it's visible on a form or not.

John W. Vinson[MVP]