The situation...

I have a form with 4 combos, one parent and three childs.
I have a few command buttons.

When I select the parent the child combo are activated, then when one
of the childs is changed, the contents of the other two child boxes are
poulated with related data.

If I want to delete the data, i.e. click the delete button, how can I
find out which was the last child box changed?

I've thought about using a public variable to store a value based on
the last box changed, (1 for combo1 etc) but is there any other way of
doing this cleanly?

ta,
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=535458