Clearing data in a Form

[APS]

I have a form, part of which is a set of nested queries. They are in a set of
combo boxes, the entry in the first one limits the list in the second one.
This goes on for 5 levels. I can clear the combo boxes by setting them back
to NULL. However, they seem to remember the last data that was in them and
will not allow new entry in the box 1 to set a new list in box 2 and so on.
If I requery, it seems to break the nesting.

Any Ideas on how to clear the boxes and keep the nesting. By the way closing
and opening the form works, but the form is so complex that the delay is
unsatisfactory and it also deletes other info that I don't want to clear.

 

[APS]

A little added info. I usually work with Macros not code, but can follow code
if it is not too complex.

 

[APS]

I am on another fire drill right now so I haven't had a chance to check your
solution yet, but I am doubtful. The reason is that I need the values from
all the combo boxes to fill out the final report/form. I still might be able
to use your solution with a litle judicious reprogramming of how I set up the
comboboxes.

In any case I really appreciate your taking the time to help me.