Tony:
On the change event of the category combo box something like...
(assuming...first category box is called "CatList" and second item box
is called "Man"...change to suit)
Private Sub CatList_Change()
If CatList.Value = "Cars" Then
CatName.Caption = "Postal Duties"
Man.Clear
Man.AddItem "BMW"
Man.AddItem "Lexus"
End If
If CatList.Value = "Lorries" Then
CatName.Caption = "Levy Duties"
Man.Clear
Man.AddItem "Lorry make 1"
Man.AddItem "Lorry make 2"
End If
End Sub
then in the change event of the second box, do something similar to
above to fire the sub you want to fire based on the value in the box
after update
Hope this gets you going
Duncan
Tony wrote:
> How do I make the hide/unhide for my selection?
Bookmarks