tab control issue

[Guest]

Hello. I have a form with a tab control on it. What I would like to be able
to do is make some of the tab control pages invisible until the user checks a
checkbox at which time the page will then appear. I've gotten the page to
appear/disappear when the checkbox is checked/unchecked using the checkbox
click event. But, what I have a problem with is when the user changes
clients and the tab control changes information to the selected client. It
is a checkbox that not all clients would have checked. I placed the checkbox
click info (simple IF statement) into the tab control change event but
nothing occurs.
Does anyone have any ideas on how to get this to work?
Thanks in advance for any assistance.
*** John

 

[Brendan Reynolds]

When you say 'changes clients' do you mean 'moves to a different record'? If
so, you need to place the code in the Form_Current event procedure.

 

[Guest]

Brandon, the answer to your question is 'yes' and your suggestion worked.
Thanks.
*** John

 

[Guest]

Brendan, there is another issue regarding this. When I select the first
client and the information fills in, the tabs will not appear from the first
selection of the client from the drop list. The form is unbound until the
client is selected. In the forms current event I placed the following:

If Me.chkProjectOwnerAssigned.Value = True Then
Me.pagProjectOwner.Visible = True
Else
Me.pagProjectOwner.Visible = False
End If

There are series of checkboxes on the front tab page that the user may or
may not check. Their action/need would dictate whether the appropriate tab
page would appear or not.
Any thoughts on this?
Thanks again.
*** John

 

[Brendan Reynolds]

I'm sorry, I'm afraid I don't understand what the question is.

 

[Marshall Barton]

Brendan, there is another issue regarding this. When I select the first
client and the information fills in, the tabs will not appear from the first
selection of the client from the drop list. The form is unbound until the
client is selected. In the forms current event I placed the following:

If Me.chkProjectOwnerAssigned.Value = True Then
Me.pagProjectOwner.Visible = True
Else
Me.pagProjectOwner.Visible = False
End If

There are series of checkboxes on the front tab page that the user may or
may not check. Their action/need would dictate whether the appropriate tab
page would appear or not.

I agree with Brendan that this is very confusing, but I
suspect that you need to make something(?) visible in the
client selection control's AfterUpdate event.

Maybe you want to do the same(?) check box procedure?? Or
maybe just set the tab control's value to the desired
page???