I was entering the SQL programmatically when getting the syntax error. John Koziol lead me to a fix for my situation. I just coded the select statement and programmatically set the rowsourcetype to 2(alias) and the rowsource = alias.
Your method idea sounds good also, thanks for the help.

>I believe that this limitation is only true when entering the SQL in the properties sheet. Try Building the string in code and assigning the rowsource programmatically.
>
>If this doesn't work, create a method called something like populatelb and exewcute your query in there. In that method, you can scan through the results and use Additem. You would then call this method instead of listbox.requery().