I'm using a multiselect list box in Access 2010 and trying to set the
'Selected' value for a list row using:
With me!lstCont
.SetFocus
mCurrentIndex = .ListIndex
.Selected(mCurrentIndex + vIntegerValue) = True
End With
But the result is the original item still being selected.
Using .ListIndex = mCurrentIndex + vIntegerValue gives the same result

On a second form, the above seems to work, but I can't work out how to
ensure that a selected row (using VBA) is visible when the ListCount is
greater than the number of rows displayed.

Any help would be appreciated.

--
Bob Darlington
Brisbane

Check what Stephen Lebans has at http://www.lebans.com/List_Combo.htm



Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele
Co-author: "Access Solutions", published by Wiley
(no e-mails, please!)


"Bob Darlington" wrote in message
news:4e40df98$0$2442$afc38c87 (AT) news (DOT) optusnet.com.au...

I'm using a multiselect list box in Access 2010 and trying to set the
'Selected' value for a list row using:
With me!lstCont
.SetFocus
mCurrentIndex = .ListIndex
.Selected(mCurrentIndex + vIntegerValue) = True
End With
But the result is the original item still being selected.
Using .ListIndex = mCurrentIndex + vIntegerValue gives the same result

On a second form, the above seems to work, but I can't work out how to
ensure that a selected row (using VBA) is visible when the ListCount is
greater than the number of rows displayed.

Any help would be appreciated.

--
Bob Darlington
Brisbane