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

Gary

There is a good starting point for this in the ADH97 on pages 363-370.

Regards,
Bob Gajewski

On Friday, April 04, 2003 10:36 AM, Gary [SMTP:gjgiever at yahoo.com] wrote:
> I forgot to note that the listbox is unbound 
> 
> 
> --- Gary <gjgiever at yahoo.com> wrote:
> > 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
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> 
> 
> =====
> Gary
> 
> Some people are born on third base and go through life thinking they hit a triple. 
> Barry Switzer (1937 - )
> 
> Jesus loves you...then again, so does Barney 
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - File online, calculators, forms, and more
> http://tax.yahoo.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>