Open a form and display last record

[RyanB]

Hi,

I've searched for this but can't find how to do it, When I open this form I want it to display the last record in its control source, This is probably a simple one but I just can't seem to make it happen...

Thanks

Ryan

P.S. This is what i Have so far...

DoCmd.OpenForm "frmAbout"

 

[ghudson]

Assuming you know that a table does not store [sort] the records in any particular order and that you do not want to sort the record source in the decending order...

DoCmd.RunCommand acCmdRecordsGoToLast

 

[RyanB]

Worked like a charm. thanks