Sort Records on subform

[gheyman]

I have a table from which I created a subform. I assume it automatically put the records in order by creation (oldest first...). I want to see the last record created first (descending).

Is there a way to have the records on my subform resort?

 

[Joe4]

I never base Forms or Reports directly on Tables. I always go through a Query, where you can do calculations, filter records, and add sort orders.
So I would recommend create a Query from the Table where you add the Sort. Then, use that query as the Record Source of your Form.
After your create this query. you should be able to easily update your existing Form (SubForm), going to the Properties, and changing the Record Source property.

 

[ParamRay]

Change the subform's record source to something like:

SELECT * FROM [TableName] ORDER BY [ID] DESC;

Obviously, replace [TableName] with the table's name. Here, [ID] represents the primary key, which is (hopefully) an autonumber field.

 

[gheyman]

Thank You!