Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

clear results in listbox?

Status
Not open for further replies.

AccessDevJunior

Programmer
Apr 14, 2004
81
GB
hya,

i have several list boxes which retreive data from a ms access database, when the user's selects to perform a new search i wish the listboxes to reset so they are not displaying the results from the previous search.
if anyone can show me how to reset the results in my listboxes it would be a great help?
 
list1.Clear

Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.
 
example:
Code:
Private Sub Text1_Change()
   If Text1.text = "" Or Empty Then List1.Clear
End sub
Code:
Private Sub Combo1_Change()
   If Combo1.text = "" Or Empty Then List1.Clear
End sub
etc.... etc.....

---------------------------------------
This will be the day when all of God’s children will be able to sing with a new meaning, “My country, ‘tis of thee, sweet land of liberty, of thee I sing. Land where my fathers died, land of the pilgrim’s pride, from every mountainside, let freedom ring. - Marten Luther King
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top