Hi Joe and Ken,
Joe - your question was very helpful ! I was trying to accomplish the same
and having issues, it helped me a lot.
Ken - Your answers were excellent!!
But I am still having an issue ... I open the form, make a selection for
each the combo boxes, then if I go back to the first combo box (store) and
make a second selection, the second combo box (manager) clears but the third
one (employee) still shows my original selection. I did try the AfterUpdate
event producedure in the form's Current event as suggested but it does not
work.
I have used Joe's example - same tlb names, and cbo names.
Also please would you be able to share the code to create a table you've
referred above?
Thanks a lot.
Nina
