Information générale
Catégorie:
Codage, syntaxe et commandes
>>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
Thanks a lot everybody! Finally got it. I changed the field name from Type to Category, changed the ORDER BY to 1 and tried putting quotes around the statement (although I have done dozens of them without it). Nothing worked. So I deleted the control from the form and put it in again, with the table change in place. Works like a charm now.
I really appreciate all the help . . .
John
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement