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