Reverse Order

[James]

How do you make a form display in reverse order by using the date field
(fldDateUsed)?

 

[Nikos Yannacopoulos]

James,

Do you mean display the most recent dated records first? If yes:

If the form's recordsource is a query, then open the query in design view
and set the sorting on the date field to descending;

If the form's recordsource is directly the table, then open the form
indesign view, select the form object, display properties, and on the Data
tab set the Order By property to:
fldDateUsed DESC

HTH,
Nikos

 

[PC Datasheet]

Base your form on a query and set fldDateUsed to sort. Sort Ascending to see
the earliest date first and as you navigate the records you will continually
see the next chronological record until the last record is the most current
record. Sort Descending to see the most current record first and as you
navigate the records you will continually see the previous chronological
record until the last record is the earliest record.