making some text-boxes invisible in tabular form based on the value of one field

[Rafegh]

Dear all,
hi

I have designed a tabular form to enter records into a table. I have so many fields in each record, but some of them are not needed to be filled according to the value of one of the fields. how can I make these unneeded fields not visible based on the value of one field?
I have tried to write a code for that in vba and it works, but the problem is that when i use this code, the fields disappear in all of the records shown in tabular form based on the value of the conditioning field in the first record.

[Bob Fitz]

Can you show us your code.

[ranman256]

No.
tabular fields are either on or off for all recs. Not some.

[Rafegh]

This is my code:
If LayerType.Value = "Subbase 1" Then


BitumenType.Visible = False
Label62.Visible = False
Label63.Visible = False
Label64.Visible = False
Label65.Visible = False
Label66.Visible = False
Label67.Visible = False
Label71.Visible = False


BitumenPercent.Visible = False
Strength.Visible = False
Flow.Visible = False
Void.Visible = False
VFA.Visible = False
Text70.Visible = False


End If