Simple Question ...

  • Thread starter Thread starter Nocturnl
  • Start date Start date
N

Nocturnl

I'm doing a very simple form,

I need a combobox to be visible after a selection is made in the previous
combobox

my code is:

Private Sub Current_status_AfterUpdate()
Select Case Current_status
Case "poor"
Me.Poor_why.Visible = True
Me.Poor_why_lbl.Visible = True
End Select
End Sub

When i preview the form the combobox i've made visible = false is still
visible ... am i doing something incorrect, thankyou
 
On Thu, 6 Dec 2007 05:20:00 -0800, Nocturnl

Add a Case Else to set both controls Visible=False.
And at design time set them both to False as well.

-Tom.
 
On Thu, 6 Dec 2007 05:20:00 -0800, Nocturnl


Add a Case Else to set both controls Visible=False.
And at design time set them both to False as well.

-Tom.








- Show quoted text -
Click to expand...

You may also want to consider adding some code on the forms load event
to hide the necessary combo box, and then only after the selection in
the preceding combobox is made will the secondary be visible.
 
Back
Top