Need Help Putting Dates in Order...

[dgaletar]

Hello. This is how my form currently displays:



As you can see, the dates are all messed up. I need them to show NEWEST to OLDEST.



The list of dates is pulled in from the following code:

Private Sub Date_Click()

DoCmd.OpenForm "Service Details", acNormal
Forms![Service Details]![CustomerID].Value = Forms![Vehicles]![CustomerID].Value
Forms![Service Details]![Service_Date].Value = Forms![Vehicles]![Service subform]!Date
Forms![Service Details]![Service Work Item Xref subform].Requery

End Sub

I am sure that this is a fairly simple fix, but I don't know it. If anyone can help, I would surely appreciate it!!!

Thanks,

DG

[ssanfu]

It looks like the subform that is displaying the date and mileage is in datasheet view, and I am guessing the datasheet record source is based on a table. The form record source should be a query. Record sources that are queries can be ordered (sorted) whereas a table cannot.

So change the record source to a query and set the sort order to the date descending.

I never use datasheet view; if I needed that look, I use continuous forms view and create my own datasheet look. IMO, datasheet view is very limiting.


BTW, "Date" is a reserved word in Access and shouldn't be used for object names.
Here is a list of reserved word: http://allenbrowne.com/AppIssueBadWord.html

[Missinglinq]

...Record sources that are queries can be ordered (sorted) whereas a table cannot...

Actually you can do this with a Table as the Record Source:

Make sure that the Form's Order By On Load Property is set to Yes

Set the Order By Property to: [YourDateFieldName] DESC

Just like that, with Square Brackets around the YourDateField Name, followed by DESC.

Having said that, it is considered preferable, by many experienced developers, including myself, to base all Forms on Queries, even when only a single Table is involved. And doing this sorting in a Query is how I'd do it.

Also pay particular attention to ssanfu's advice about not using the Reserved Word Date as a Field name!

Linq ;0)>