>I have a combo box whose RowSource is SQL. The statement is as follows:
>
>SELECT DISTINCT Lookup.Type FROM Lookup INTO CURSOR csrType ORDER BY Type
>
>When I paste this into the command window, it works beautifully. However, when I run my form, the combo box is empty. When I press the Verify button in the Expression Builder of the control, I get the lovely "help" message: Syntax error. If there is a syntax error, why does it run in the command window???
>
>Anybody see what's wrong with this statement?
>
>TIA,
>John
Just in case, did you selected the RowSourceType="SQL Statement"? In the same lines as Jim Nelson, you can replace using the "ORDER BY Type" at the end with "ORDER BY 1". HTH