Default to last record on a Form ?? Please Help?

's Computer Specifications

Hi All

I am trying to show the last record when a form opens in edit mode. This
form has numrous records and it defaults to the first record only.

Can this be done?

Appreciate your help!.

's Computer Specifications

In the Load event procedure of the form:

If not Me.NewRecord Then
RunCommand acCmdRecordsGoToLast
End If

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Manny" <(E-Mail Removed)> wrote in message
news:e7g03e$ft2$(E-Mail Removed)...
>
> I am trying to show the last record when a form opens in edit mode. This
> form has numrous records and it defaults to the first record only.
>
> Can this be done?
>
> Appreciate your 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 a form	Manny	Microsoft Access	1	26th Jun 2006 07:38 PM
Default to last record on form?	Manny	Microsoft Access Forms	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