Query behind field on form not working

[marathonlady]

I have a form with a field that I have SQL in for the record source. However,
when the form opens the field is displaying the table that is used in the query.
ie, the fields are in order of the table not the query. When I put the form in
design mode and click into that field and run the query, leave the form and open it again the field is okay. Has anyone encountered this?

Thanks.

 

[Dreamboat]

So the records are right?
Then the query IS working, but it's not sorted properly?
Did you choose a sort on your form?