G
Guest
Hi, I have a form which has two combo boxes on it. The 2nd is populated
depending on the data entered in the first box. I have an intermittent
problem with it, sometimes instead of displaying the query results in the
combo box an error occurs:
'The SELECT statement includes a reserved word or an argument name that is
misspelled or missing, or the punctuation is incorrect'.
If you run the query manually that is specified in the source of the combo
box the results appear ok. I don't think there are any reserved words etc so
I don't know how to solve this. I have tried changing field/table names just
in case and this worked at first but the occur has occurred again. Anyone any
ideas?
SQL view of query combo box source refers to:
SELECT [Systems Functions].SysFuncID, [Systems Functions].SystemID, [Systems
Functions].FunctionTitle
FROM [SCR Systems] INNER JOIN [Systems Functions] ON [SCR Systems].SystemID
= [Systems Functions].SystemID
WHERE ((([Systems Functions].SystemID)=[forms]![SCR New]![cboSystem]))
ORDER BY [Systems Functions].SystemID, [Systems Functions].FunctionTitle;
depending on the data entered in the first box. I have an intermittent
problem with it, sometimes instead of displaying the query results in the
combo box an error occurs:
'The SELECT statement includes a reserved word or an argument name that is
misspelled or missing, or the punctuation is incorrect'.
If you run the query manually that is specified in the source of the combo
box the results appear ok. I don't think there are any reserved words etc so
I don't know how to solve this. I have tried changing field/table names just
in case and this worked at first but the occur has occurred again. Anyone any
ideas?
SQL view of query combo box source refers to:
SELECT [Systems Functions].SysFuncID, [Systems Functions].SystemID, [Systems
Functions].FunctionTitle
FROM [SCR Systems] INNER JOIN [Systems Functions] ON [SCR Systems].SystemID
= [Systems Functions].SystemID
WHERE ((([Systems Functions].SystemID)=[forms]![SCR New]![cboSystem]))
ORDER BY [Systems Functions].SystemID, [Systems Functions].FunctionTitle;