>>>Of course then I do a requery on the view. Even entering your sugggestion directly while in the RUN QUERY of the view designer doesn't work.
>>>
>>>I'm baffled... but thanks for tryin'!
>>
>>IN doesn't work well for that technique - have you tried INLIST()?
>
>
>I solved it by using 3-SQL as the rowsourcetype and then using the '$' operator.
>Since INLIST() isn't a choice in the view Designer, I didn't try that method.
No, you have to do that by code; it works just like the '$' operator for lists of items, except it is optimizable, so could be faster...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.