Hi Neil.

Can anybody tell me how you can clear the contents of a list box. the list box is for information only from an SQL query. No selections of records will take place inside the list box.

Change your RowSOurceType to 0-None and populate the listboc with the query results using its AddItem() method. Then, when you want to clear the list box, you can just use its Clear() method.