Posted on 2011-03-23
I have an issue with "old" data appearing inside list boxes on a form.
The list boxes are named such as lstRange1, lstRange2, lstRange3 and so forth.
What happens is, I use VB to populate the list boxes when the form opens (as part of a refresh process), however, not all list boxes are populated depending on some conditions. For example lstRange1 might have data but lstRange2 and lstRange3 might not be required. These are greyed out.
My initial thought was to set each list box rowsource to "" on the FormLoad or FormOpen event to make sure that each of the list boxes were blank prior to populating the form with data. However, a colleage mentioned to me that I could use the requery method but I cannot pin point any solid examples as guidance.
Anyone got any suggestions?