true or false on tabbed pages visibility

[Squibbly2]

i got tabbed pages on my form


and the coding for this goes like this
If xxxx = False Then
Me!Page2.Visible = False
Else
Me!Page2.Visible = True

xxxx is a yes/no control as you may aswell know, the problem is when this is
true or false then the whole form either goes from visible or non-visible
regardless what record is shown. how do i do this for specific records or
can't i do that?

 

[Rick B]

You would need to put this event in the ON CURRENT event so that it fires as
you move from one record to another.

 

[Squibbly2]

the yes/no control does not have a ON CURRENT event

 

[Squibbly2]

ooh i get ya thanks does the job but not as i expected, i expected it to
show up as soon as i clicked it not when i move to a new or previous record

 

[Rick Brandt]

ooh i get ya thanks does the job but not as i expected, i expected it to
show up as soon as i clicked it not when i move to a new or previous
record

You need the code in both places, the current event of the form and the
AfterUpdate of the control.

 

[Squibbly2]

ok thank you for you advice
cheers

You need the code in both places, the current event of the form and the
AfterUpdate of the control.