I am using a listbox and additem method.
The database has multiple same names...Ie..White Carol may be in the database 5 times with 5 different criteria. I want to load White Carol in my list box only once. Once loaded I can click on White Carol and display her five different entries by reading the database.
I load using
While not data1.recordset.eof
How do I load White Carol only once leaving the database as it is?