[RESOLVED] Applying Sort to a Form

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

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.

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