Making a control disappear based on input in a textbox

[lintonra]

I have a textbox on my form that i only want to appear when the user
slects a certain value in a combo box. This piece works. However, when
the user proceeds to anotehr record the textbox is still visible on the
form despite the condition not being true.

 

[xRoachx]

Two things:

Set the Visible property of the textbox to False and add a second statement
to the IF:

If combobox.value = "Whatever" then
txtbox.visible = true
Else
txtbox.visible = false
End if

 

[Van T. Dinh]

Use the Form_Current Event also to check the criteria and show / hide the
TextBox if required.

 

[lintonra]

Thanks!!!!!!