reserved word error

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;
 
G

Guest

Sorry, think I have fixed it now! Another field had an incomplete select
statement in its after update event. I removed this and I think it has solved
it, it must have intermittently been trying to use this as the source rather
than the query in the combo box. Sorry for the posting and thanks anyway!!!
Sue

Ken Snell said:
What is the data value that you enter that seems to cause this problem?


--

Ken Snell
<MS ACCESS MVP>

hughess7 said:
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;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top