>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,

Set the RowSourceType of the listbox to 3 [SQL Statement]. For the RowSource, put in that SQL command.

Now when you need to update the records for the listbox, just issue a ThisForm.ListBoxName.Requery()