How can I force selection of the 1st record of multiselect listbox from VB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Max Moor - 13 Feb 2008 18:17 GMT

Hi All,

I'm still stuck on this. I have a multiselect listbox in Access 2002.
I want to force the first record to be selected from VB after the listbox is
requeried. As I understand it, the value property always reads Null in this
case. Trying to set it doesn't work, so I assume this is a two way street
for multiselects.

Can anyone help?

Regards,
Max

Reply to this Message

Mark A. Sam - 13 Feb 2008 22:35 GMT

Max,

If your listbox was named [myListBox] then the method would be

[myListBox].Selected(1) = True

God Bless,

Mark A. Sam

> Hi All,
>
[quoted text clipped - 10 lines]
> Regards,
> Max

Reply to this Message

Max Moor - 14 Feb 2008 05:53 GMT

"Mark A. Sam" <MarkASam@EmEssEn.Com> wrote in news:uwxd1CpbIHA.4208
@TK2MSFTNGP04.phx.gbl:

> myListBox].Selected(1) = True

Hi Mark,

     Well. That was rediculously simple. I had managed to get stuck on the
'Selected' property being read only. I even briefly considered that you were
crazy to even suggest writing it as a solution.

     Of course, I have no idea where I got that idea now. I just got it in
there somehow, and couldn't see past it. Maybe it's time for a day away?

     Thanks for the wake up call. :-)

- Max

Reply to this Message