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