One selection in dialog box controls two listboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using this code in my dialog box:
Private Sub Frame22_Click()
Me!List18.Visible = (Me!Frame22 = 1)
Me!List12.Visible = (Me!Frame22 = 2)
End Sub
I have two more listboxes I would like to work in sequence with the above.I
would like to add List20 to List 18 and List16 to List12. I have 2 sets of
listboxes stacked and would like to have one set visible or the other. I hope
this makes sense.
Thanks
 
I made it work. There is probably a better way to do it, but I got the
results I wanted:
Private Sub Frame22_Click()
Me!List18.Visible = (Me!Frame22 = 1)
Me!List20.Visible = (Me!Frame22 = 1)
Me!List12.Visible = (Me!Frame22 = 2)
Me!List16.Visible = (Me!Frame22 = 2)
End Sub
 
Back
Top