>Thanks for the help. I will probably put the SELECT statement directly into the RowSource as Trey mentioned. But I will consider your suggestion and print it out for future reference. Thanks again.

You don't necessarily have to put the SELECT statement in the RowSource. The RowSource can be a call to a function that does the actual SELECT.