Show last page

[mtagliaferri]

I have a form with records in chronological order, as this has hundreds of records I would like to open the form and go to the bottom of the form to display the most recent records by date in the window, I know I could invert the order of the records displayed but I rather have them sorted by chronological order 1->999
Any help?

 

[jdraw]

Could you change/filter the record source of the form to only include the latest 5, 10 or however many dates?

 

[BlueIshDan]

change the query to have an order by date desc or asc not sure what one you're looking for.

 

[JHB]

Put the below line in the form's On Open event:

DoCmd.GoToRecord , , acLast

 

[mtagliaferri]

Thanks very much, that's exactly what I was looking for!!