text box visibility

[Guest]

I have made a form on which there are nine groups of seven characteristics
describing a product. They are all text boxes, and the page is clutered.
For each product at least half of the groups of text boxes are blank. I want
to make the first text box be the deciding factor in whether or not the
following six boxes are visible. If the first box is null, when scrolling
through records I do not want to see the other boxes.

 

[Guest]

I have made a form on which there are nine groups of seven characteristics
describing a product. They are all text boxes, and the page is clutered.
For each product at least half of the groups of text boxes are blank. I want
to make the first text box be the deciding factor in whether or not the
following six boxes are visible. If the first box is null, when scrolling
through records I do not want to see the other boxes.

 

[Guest]

Further to S. Panja's reply, if the form has records for each product then
put the code in the On Current event, not the On Open event

 

[Guest]

The problem is that every record has different groups populated. Is it
possible, when scrolling through the records, to make every record show only
the groups for which the first text box is populated?

 

[Guest]

The on current event fires when you scroll through the records so something
like the following in the On current event should do what you are after
If [TextBox1] = "Something" then
[TextBox2].Visible = False
[TextBox3].Visible = True
[TextBox4].Visible = True
[TextBox5].Visible = False
etc.
else
if [TextBox1] = "Something Else" then
[TextBox3].Visible = False
etc.
end if
end if