visible or not 1

[matrixindicator]

I have a form with a lot of buttons. A few text fields are not feed by a query or table but with the value of a button.
However one textfield is dependent of a value of the table.
"Emballage"
"Emballage no"

I set a drop down list with get the actual value "Emballage (no). I get the value. But depending of this value he should set visible or not a textbox. I don't know on with action or event to let work my if statement. I tried many event. Or other ideas.

 

[matrixindicator]

Found, set it in the function of a button. The dropdown box is set to hide (not visible).

If Forms!F01_ORDER!txtBAKGEEN.Column(1) = "NO EMBALLAGE" Then
Forms!F01_ORDER!txtBAK.visible = False
Else
Forms!F01_ORDER!txtBAK.visible = True
End If

 

[PHV]

A shorter way:
Forms!F01_ORDER!txtBAK.Visible = (Forms!F01_ORDER!txtBAKGEEN.Column(1) <> "NO EMBALLAGE")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886