Why is it so? (1 Viewer)

[John Sh]

I have a simple select query that results in a list of items governed by another item.
When run from the query design, it provides the correct information. When run from a form I get a list of responses that starts at "S" goes to "Z" and continues from "A" and finishes at "T".
This same list appears regardless of the criteria fed to the query from the form. This query was working previously but since i made some changes to the form layout I get this behaviour. I have checked, and double checked, for errors. Running in debug mode it appears that the correct data is supplied to the query.
Any thoughts greatly appreciated.

 

[arnelgp]

what is the SQL query?
do you have any code in the form?
do you have Order By property on the form?

 

[John Sh]

Please ignore the above message. I found a period instead of a comma.

 

[Isaac]

Please ignore the above message. I found a period instead of a comma.

Happens to everyone