Mark,

I have used to the second SQL statement and it works fine. I don't understand why what I was tring would not work though. I thank you. However, I have another problem. If I take this same SQL statement and put it in the click event of the list box(to update the list box) when I try to refresh the rowsource I get an error that the table is not accessable. Can you help with this also?

God Bless,
S. Dyke