>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.
OK Jim. I tried it out last night and it worked perfectly. I am going to see if I can test the \ option under various RowSourceTypes and if I find out anything interesting I'll post it here. Thanks for all your help.
***************************
Bruce Gilmour
"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein