[RESOLVED] Applying Sort to a Form

[Strider]

I have a form that is based on a database table.

when i opened the form i would like it to sort the data according to the data, without having to use the Apply Filter/Sort on the Form.

i also have a filter on the form but i do not want the to be applied with the sort/

how can this be done

[alex_read]

You could sort the database when you first retrieve the data, by using a SELECT SQL statement with a ORDER BY clause added to the end.

[Strider]

this done by attaching the record source of the form to a query