>Ever try to change the field name which is used by order clause ?
>if it is a simple view for a listbox, why don't you try to use 3-sql statement as your listbox.RecordSourceType ? it's easier than using a view as recordsource

I'll try changing that field name. I can't use 3 because I need to be able to change the order on the fly.

Thanks,

-Michelle