[AccessD] Clear item from listbox

Have you tried...

Sub ClearListBox(lst As ListBox)
Dim sRowSource As String
    sRowSource = lst.RowSource
    lst.RowSource = ""
    lst.RowSource = sRowSource
End Sub

...?

Lambert

> -----Original Message-----
> From:	Susan Geller [SMTP:sgeller at cce.umn.edu]
> Sent:	Monday, December 08, 2003 11:32 AM
> To:	accessd at databaseadvisors.com
> Subject:	[AccessD] Clear item from listbox
> 
> I have a listbox and I want to clear all items selected in it.  To do
> that, I am executing a stored procedure.  But, even when I've done that,
> the first row in the listbox remains selected.  Is there any code that
> will unselect all items in a list box?  I'm in an adp in Access XP.
> 
> --Susan
> 
> 
> Susan B. Geller
> Office of Information Systems
> College of Continuing Education
> University of Minnesota
> 306 Wesbrook Hall
> 77 Pleasant Street SE
> Minneapolis, MN 55455
> Phone:  612-626-4785
> Fax:  612-625-2568
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com