Setting form and subform visiblility

T

TimT

I have a form with serval tabs and subforms.
Based on the client choices i want to make certain forms and tabs visible
and some not.
I would also like it to update when a new record is selected with different
choices then the current one.
Can someone help me out??
 
A

Alex Dybenko

Hi,
you can detect new record using form's .NewRecord property in Current event,
and then set corresponding controls .Visible property to true or false
 
T

TimT

Hey Alex thanks for the reply..
This is a new one for me so you elaberate on it?
This is what I would like to do:

If field1.Value = "1" Then
tab1.visible= FALSE
tab2.visible=TRUE
Else
tab1.visible=TRUE
tab2.visible=FALSE
End if

Field1 is populated from a toggle button with a 1 or a Two.
 
Top