>Jim,
>
>Does this only work for rowsourcetype None or does it work in other types as well. I tried using a backslash with a SQL statement (type 3 I think) and it didn't disable the selections.
>
Bruce,
The addlistitem only works for rowsourcetype of none. If you want an sql then put it in the requery of the combo and then scan that cursor to do the addlistitem calls.
I very seldom use a combo or list wihtout the rowsourcetype being none and using the addlistitem to populate the list. It is much more flexible and doesn't have any performance hit when the list has 1,000 or less items in it. Since using a list or combo with more than 1000 items is a questionable interface design, it doesn't matter to me what happens beyond that level.