tabs and counter

[Lauren B.]

I have two questions regarding forms:

1. I have three tabs on a form that contain several check boxes. When the
users clicks "vendor involved," I want the "vendor info" tab to appear. If
this box is not checked, I do not want the tab to be visable. Is there a
way to write this into the event procedure?

2. I have created a subform on a tab within a larger form. At the bottom of
the subform is a navigation bar and counter (reads 1 of 1)- is there a way
to delete this bar? I do not need multiple entries.

Thank you for your assistance.

 

[Guest]

Hi, Lauren,

1. This is controlled by the Visible property of the Tab Control. Set the
Visible property in form view to No. In the On Current event, and in the
AfterUpdate event of the checkbox, something like:

If YourCheckBox = True Then
YourTabbedPage.Visible = True
Else
YourTabbedPage.Visible = False
End If

2. Set the NavigationButtons property of the subform to No. This can be
done from editing the main form, but you must click on the subform control,
and then click its square at the top left corner to get at its form
properties. However, your question makes me wonder why you have a subform at
all. Is there a one-to-one relationship between the main and subforms? If
so, they could simply be one form.

Hope that helps.
Sprinks