[AccessD] Deselect all items from a multi-Select list box

Gary gjgiever at yahoo.com
Fri Apr 4 09:25:09 CST 2003


I'm using Access97 on Windows XP.  I have developed a
simple application to track which tables are used by
various applications that I have developed.  The main
form has a multi-select listbox with all the tables. 
The main form is bound to the table with all the
applications.  I select all the appropriate tables for
the application in the listbox then a command button
adds all the selected tables to a third table that
lists all the tables for each application.  

My problem is that when i navigate to another
application all the tables that I selected for the
previous application are still selected.  I can go
through and manually deselt each item or close the
form and reopen it.  There must be an easier and more
elegant way to clear the listbox.  I researched this
and found one other person who asked this question but
no one replied.  It seems like it should be easy to
do. 

Gary J. Giever, MA
ACCMHS

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com


More information about the AccessD mailing list