multiselect listboxes

[Guest]

I am trying how to figure out how to set the value property of a multiselect
listbox (multiselect property = extended) programatically when the form
opens. However, Access only wants to let me set it in a listbox where the
multiselect property = none. Any ideas?

Thanks so much!

 

[Douglas J. Steele]

You cannot bind a multiselect list box: you have to set which rows are
selected manually by looping through the its rows, setting the Selected
property of each row to be selected to True.

 

[Guest]

I did exactly that. But the user has to scroll down to find the selected row
as the selected row does not appear automatically.

Thanks.