Control on a form "unhides" itself on all records

G

Guest

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.
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top