Problems with visible and combo boxes

[Guest]

I have managed to get a text box to go between visible and not using:
If Me![ComboBox] = "Bad" Then
Me![Label_TXT].Visible = True
Else
Me![Label_TXT].Visible = False
End If

My problem is that when I go to my next record, the text boxes that had
changed to visible before are still visible. I want them to go back
invisible for every new record.

My other problem is that when I close the form and then reopen it, the text
boxes that have bad in their corresponding combo boxes are not visible.

Any suggestions?

 

[John Vinson]

My problem is that when I go to my next record, the text boxes that had
changed to visible before are still visible. I want them to go back
invisible for every new record.

Put the same code in the Form's Current event. This will fire whenever
you move to a different record, and set the visibility appropriately
for that record.

John W. Vinson[MVP]