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

Will Me.MyListbox = "" or Me.MyListbox = Null work?

R

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Collins, Darryl
Sent: Sunday, January 03, 2010 8:36 PM
To: Access Developers discussion and problem solving
Subject: [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."

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com