General information
Category:
Coding, syntax & commands
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only