Sort Data on my form

[romio]

When I open my form the data are sorted through the ID, How can I change that to be sorted through the Year? On my form properties is that the Filter is responsible for sorting?

 

[iago18]

The best way I know is to set the RecordSource of the form. I assume currently that the recordsource is bound to a Table. Instead:

1. Set the form's recordsource to a Query which is simply requesting all records from the source Table
2. In the query set the Sort property of the field you want to sort by to Ascending.

 

[romio]

The best way I know is to set the RecordSource of the form. I assume currently that the recordsource is bound to a Table. Instead:

1. Set the form's recordsource to a Query which is simply requesting all records from the source Table
2. In the query set the Sort property of the field you want to sort by to Ascending.

Thanks iago18.

 

[romio]

well its not working yet, even though i have it sroted, the last record will always appear as last record, Why?

 

[romio]

i have tried have a refresh command box with the following:

Dim strSql As String
strSql = "SELECT Records.ID, Records.Name, Records.Description, Records.Department, Records.ProblemDesc, Records.SolutionDesc, Records.ITName, Records.RDay, Records.RMonth, Records.RYear, Records.RTime, Records.AMPM FROM Records ORDER BY Records.RDay, Records.RMonth, Records.RYear"

But still not working

 

[iago18]

Have you taken the SQL string you've created and set it as the RecordSource of the form?

1. Open the form in Design View
2. Right click on the Form and select Properties
3. Find the form's Recordsource property, click into it, then select the '...' button next to it
4. Set the recordsource of the form in here using a query like the one described in your SQL statement.