>Why don't you suggest using it in comboboxes? It seems like a perfect solution to a problem that has been bugging me a long time. I don't actually use comboboxes much anymore, but if I do in the future, this will be handy.
>
>Thanks,
>
>Michelle
If you want to use SQL as RowSourceType, I guess, it might work. I checked our classes and they use SQL as RowSourceType, but select into cursor.
I'm working on some complicated report right now, so can not test.
>
>>It works, since it was taken from one of our classes :)
>>
>>But I would not use it in comboboxes. This was used to check field for uniqueness, so we only want to check, if this SQL produces records (_Tally) and result is not needed.
If it's not broken, fix it until it is.
My Blog