Originally Posted by
June7
Not really enough info.
A multi-value combobox must be bound to a multi-value field. Recommend against use of multi-value field.
Also, I don't think VBA can directly select items of multi-select combobox list. VBA can save values to multi-value field. The code is rather complex.
But again, advise not to use multi-value field.
Thank you for your reply. I am currently using this code:
"Me.[Combobox].SetFocus
Me.[Combobox].ListIndex = 0
Me.[Combobox].Selected(0)=True" ===> this will select the first item in the list.
Actually this code works. I just want the part of the code that will identify what needs to be selected.
I will try to provide more input:
I have two variables S and E that may go from 0 to 10, E always being greater than S.
Depending on the values taken by these two variables, I want to select several items from my Combobox.
if S = 1 and E = 5, I want then to select items 1,2,3,4,5 (set them to true in my code above).
Thank you!