Simple Question ...

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
 
T

Tom van Stiphout

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

k_gotberg

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