Hide/Show again! (1 Viewer)

[RussG]

Posted this problem last night, got a reply that worked. Tried the same thing this morning in another DB and it won't work. Can anybody tell me why?

I have this code in the 'afterupdate' and 'on current' events:

'if other is selected show txtBox1, if anything else is selected hide txtBox1'

If Me!cboBox9 = "Other" Then
Me!txtBox1.Visible = True
Else
Me!txtBox1.Visible = False
End If
This is the same as my post last night except I was using yes/no.

Using the above txtBox1 is not visible anytime.

Russ

 

[DBL]

You might need to refernece the actual field in the combo box. The first column in a combo box is 0 (normally the id field which is hidden) so the description field "Other" would be column 1:

If Me!cboBox9.column(1) = "Other" Then
Me!txtBox1.Visible = True
Else
Me!txtBox1.Visible = False
End If

 

[RussG]

Thanks for your quick reply DBL. That was the answer.

Cheers

Russ