Control on a form "unhides" itself on all records

[Susan L]

I have a control (cboProd_Testing) on a form that is supposed to be invisible
unless the value in a control (cboCategory) = 2 (Application Error). What is
happening is that when I choose Application Error on one record, the control
appears on all records. I close the form and reopen, and the control has
disappeared from all records.

At first I used an If ElseIf statement, but then found another approach in
the newsgroups that I thought might cure the problem. Here is the current
code:

Private Sub cboCategory_AfterUpdate()
'Requeries the Description combo box. (This does not pertain to my
question, but it's in the code)
cboDescription.Requery
'cboProd_Testing is visible when cboCategory = Application Error.
Me![cboProd_Testing].Visible = (Me.cboCategory = 2)
End Sub

I would really appreciate suggestions on what I might do - or do differently.

 

[Susan L]

Please refer to my other post. I got a message that it wasn't posted because
of an error.