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.

 

[Linq Adams via AccessMonster.com]

actually, the concept is known as "Cascading Comboboxes" rather that "nested
queries." I just mention that because it'll be easier to find /get help in
the future using the term.

I think the problem is ***where*** you're setting the comboxes to Null.

You need to set Combobox = Null for Combobox1 in the AfterUpdate event of
Combobox2, and so forth, down the line.

Combobox1 will show the selection you made there until you make a choice from
Combobox2, then go blank, awaiting the next selection. Each combobox in turn
will do the same thing.

 

[Linq Adams via AccessMonster.com]

Sorry, forgot your comment about code:

Private Sub Combobox2_AfterUpdate()
Combobox1 = Null
End Sub

Private Sub Combobox3_AfterUpdate()
Combobox2 = Null
End Sub

and so forth.

Good luck!

 

[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.