'access combobox: move list to value

In an Access combobox CB I place in CB.value Clt, a string known to be in the dropdown list. Not by typing but by VBA code assignment. I want to ensure than the dropdown list is on the same value.

I've tried CB.recordset.movenext in a loop until I hit Clt, but this does not move the dropdown list. I've also tried CB.Recordset.FindFirst using an SQL like clause. This also does not move the dropdown list.

How can I do this? Thanks for any insight.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source