ordering dates on datasheet form

[David b]

In a reservations app I have a sub form (in datasheet view) that displays dates
in desc order. As these dates are both in the past and present I would like
current dates to appear when the form opens. ie. scroll up for future and down
for past.

Slight problem is that today may not be in the list. (Could be closed every
Friday)

Any thoughts on how to deal with this ?
TIA
David B
Hexham UK

 

[Rich]

Base the subform on a query, use the order by option to sort the dates in descending order

 

[David b]

Yep that is where I am now.
I need the a record nearest to Date() to have the focus in the list when the form opens
David b

 

[Rich]

DoCmd. GoTo Record acLast

 

[David b]

Thanks for the reply, but that wont do what I want.
David b