>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

That didn't do anything.

I got sick of trying to figure out what was wrong. It was such a simple form, I rebuilt it from scratch. It works now with the same settings as the old one. Go figure.

Thanks,

-Michelle