List boxs are the condtions in a query

[Wonderer]

I have a query that has its conditions feed by 4 list boxs degree of detaiul getting larger from the left to right. I requery each time a list box is activated but i seem to find that the list box remebers where it has been and and when you go to a different slection and want to leave 2 or 3 of the four list boxs blank it won't let you it uses the previously slected value - i was hoping somone may now the code to reset the list boxs if click on list box 1 it clears 2 - 4 likewise if i cliuck 2 it clears 3-4 and so on.

Any help would be greatly appreicted

Regards

Rob

 

[dcx693]

Have you tried setting the values of the listboxes to the right of the one just clicked on to Null? Or perhaps to a value you choose? Try Me.lstbox=Null , replace lstbox with the name of your listboxes and issue the command for each one.