Problems with visible and combo boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BBanks - 28 Aug 2006 23:43 GMT

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?

Reply to this Message

John Vinson - 29 Aug 2006 00:08 GMT

>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]

Reply to this Message