Make a field visable dependant on combo box

[torquay]

I am very new to Access and all that it entails but I have really learned a lot viewing everyones posts. I cannot seem to get my current problem solved.
I am trying to have a combo box appear depending on a preivous combo box selection.

1st combo box is "ApplianceCombo"
2nd combo box is "SpeedCombo" Set to Visible = No

1st Combo Box has
Dishwasher
Vacuum
Washing Machine etc

If they choose Washing Machine I would like my 2nd combo box to appear which they can then choose
1000
1100
1200
1300

Hope I have explained this well enough.
Thank you in advance for any help
Kim

 

[jkl0]

Try this link.

http://www.tek-tips.com/faqs.cfm?fid=4289

 

[CEH]

That link doesn't address your visibility question. You will have to activate the visibilty of the 2nd combo from an action on the first combo
On the "AfterUpdate" event of the combo an If..Then statement would work

ie.....

Private Sub Combo1_AfterUpdate()

If Not IsNull(Combo1) Then
Me.Combo2.Visible = True
Else
End If

End Sub

Or you can use a "Select Case" This is one with only 2 options "Yes" or "No"
to make a date field visible........


Private Sub Form_Current()
Select Case Me.optInterviewed
Case Is = -1
Me.InterviewDate.Visible = True
Case Is = 0
Me.InterviewDate.Visible = False
End Select

One thing to remember is it needs to be on both the field AND the form.
That should point you in the right direction........