[AccessD] List box populated with data and *nothing* selected

Hi Folks,

I am guessing not a lot of us are lurking, but here goes....

I have a form with a list box.  When the form opens and the list box is
initially populated, there is no record selected in the list.  This is a
good thing for me and how I want things to work.

When the user chooses an option in the list, it will return a record set
of filtered data in a different subform based on their choice.  All this
works swimmingly well.

What I would like is a way to return the listbox to a neutral state when
the users click on a reset option (which will return *all* records in
the other subform).

Currently the reset process works perfectly on a technical level, but on
a visual level one of the list box options is always left still
highlighted, which suggests that the filter is still applied on the
highlighted record.

I know I could use a combo box for this sort of thing (I often do), but
I like the point and click simplicity of the list box approach for this
form.

Clearly Access is happy to have the list box exist with nothing selected
as this is the default position whenever the base form is opened,
however how does one return/reset it to that state? A list box populated
with data and *nothing* selected?

Cheers
Darryl.


"This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential,  may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."