How do you clear a list box on a form?

[Guest]

What is the best way to clear a list box on a form? I have several combo
boxes on my form from which to select various fields to search on. However,
when 1 field is selected as the Search field, it displays the record in the
list box. Then if you select another field from another combo box, that
record also displays in the list box without clearning the first selected
criteria.

Thank you.
gg

 

[RuralGuy]

Maybe this will help: http://www.fontstuff.com/access/acctut11.htm

What is the best way to clear a list box on a form? I have several combo
boxes on my form from which to select various fields to search on. However,
when 1 field is selected as the Search field, it displays the record in the
list box. Then if you select another field from another combo box, that
record also displays in the list box without clearning the first selected
criteria.

Thank you.
gg

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Guest]

Would the following:
set db=nothing
set qdf=nothing
clear the entire list box?

Thanks!!

 

[Douglas J. Steele]

No.