Different sort order on form, to SQL recordsource ?

[liamfitz]

I have a mainform based on a simple query ( qryAllClients ) SQL statement i.e.

SELECT tblClients.Client_ID, *
FROM tblClients
ORDER BY tblClients.Surname, tblClients.Forename;

However, it doesn't open the form in alphabetical name order a la telephone directory style. When I 'run' the query 'standalone', it presents the datasheet view perfectly, and as expected in alphabetical order ? Would opening my mainform, which I do, at a new record, i.e just past EOF, have any bearing on this anomaly ? Can't think of any other possible reason.

 

[ypma]

Not a Programmer but long time user . using ac 2003

I am assuming you are viewing the records by Default view. Continuous Forms and require the records sorted as per your criteria I would try putting your tblClients.Surname, tblClients.Forename
Directly in the properties Data Order by: and it should work

As to the effect of opening up as a new record not sure.

 

[bob fitz]

Have you tried:

SELECT tblClients.Client_ID, tblClients.Surname, tblClients.Forename, *
FROM tblClients
ORDER BY tblClients.Surname, tblClients.Forename;

 

[liamfitz]

No bob fitz - but I will, and if not, ypma's suggestion. I take his point. ypma - it's not continuous form, it's Single Form is the Form view. Thank you both - will update you anon.

 

[liamfitz]

Your suggestion works perfectly ypma. Many thanks.

 

[ypma]

"Your suggestion works perfectly ypma. Many thanks. "

You are welcome, its very gratifying for me as a non professional programmer to receive positive feedback.