Hi Jim

>Thanks. I undertand the error when I use This or ThisForm in a procedure/function, etc. But within the RowSource of a combo of a form, well that sure feels like I'm 'within' the form to me.

Maybe, but the SQL Engine which is what you are calling to compile the query isn't! That's the root of the problem.