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!

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

How to Clear Data from the Listbox

Status
Not open for further replies.
Marryp

Marryp

Technical User
May 28, 2001
129
CA
Hi there!

How can I clear the item data from a Listbox?

Thanks.
 
Sort by date Sort by votes
a quick and dirty method is simply changing the rowsource property as :
Code: 
with me.lstbxSomething
  .RowSource=""
  .Requery
end with

Hope it helps,
Rewdee
 
Upvote 0 Downvote
The requery will not work because I have a rowsource coded in VBA and the where clause of the sql comes from the txtbox criteria.

I would like to be able to clear the txtbox and the listbox.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
712
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
392
Viswa.R
Viswa.R
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
758
Andrzejek
Andrzejek
btamsgn
  • Locked
  • Question
How to add lines from textbox to table 1
Replies
8
Views
290
MattGreer
MattGreer

Part and Inventory Search

Sponsor

Back
Top