I've searched the archives all night and not had any luck finding what I'm looking for. So, here we go:
I have a small form with two fields, both unbound, and a button. The first field is a list box fed by a query on one of my tables. The second is a text box to enter numerical data. The expected behavior would be for the user to select one or more items from the list box, enter a value in the text box and hit enter. Whereupon, the VB code will go through the selections and update several associated fields for each row in my table identified by they list box selections. This part works nicely so far.
However, once the updates are done, I need the form to clear out so new data can be entered/selected without accidentally changing something due to old selections. I set VB to change the text box to null, but how do I clear the selections in the list box? I've tried requery (on both the field and the form) as well as undo but the selections are still highlighted/selected in the list box. I've also tried setting the list box to null then doing a requery and still the old selection(s) remain highlighted/selected.
I'm sure I'm missing something amazingly simple and would sure appreciate some help in identifying it.