I would like to hide a tab based on a combo box.

my filter is based on a field, fruit.

if i filter my records on apples , I want the tabs apple1 and apple2 to be visible (and orange inivisible).
if i filter based on oranges, I want the tabs orange to be visible and (apple1 and apple2 invisible).


Does this make sense?

Thanks!

Angel

On combo box AfterUpdate event
cboSearch_AfterUpdate()
use code like this.
If combo box has value as number
If Me.cbo.column(0) = 2 Then Me.pgapple1.Visible = False
If combo box has value as string
If Me.cbo.value = "Orange" Then
Me.pgapple1.Visible = False
me.pgOrange.visible = True
END if