Default to last record on a form

's Computer Specifications

Hi All

How do I default to the last record when opening a form?

Thanks for the help

's Computer Specifications

In the form's Current event:
DoCmd.GoToRecord , , acLast

Post back if you need help with using event procedures.

"Manny" <(E-Mail Removed)> wrote in message
news:e7p8sv$gm3$(E-Mail Removed)...
> Hi All
>
> How do I default to the last record when opening a form?
>
> Thanks for the help
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Make form default to new record?	Joel Parker	Microsoft Access Forms	2	3rd Aug 2007 06:49 PM
Default to last record on form?	Manny	Microsoft Access Forms	1	23rd Jun 2006 07:34 AM
Default to last record on a Form ?? Please Help?	Manny	Microsoft Access	1	23rd Jun 2006 07:34 AM
Default value on the form field set to the max record from the tab	=?Utf-8?B?TmV3X2hlbHBfbmVlZGVk?=	Microsoft Access	0	9th Sep 2005 06:28 PM
Default open form to 'new record'?	=?Utf-8?B?RGVhbg==?=	Microsoft Access Forms	1	12th Mar 2004 03:33 PM