Open a form and display last record

RyanB

Registered User.
Local time
Today, 09:05
Joined
Jul 13, 2004
Messages
53
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"
 
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...
Code:
DoCmd.RunCommand acCmdRecordsGoToLast
 
Worked like a charm. thanks
 

Users who are viewing this thread

Back
Top Bottom