Last Record

[Guest]

How does one see the last input on a form when it is opened? I always have
to hit the end arrow on the bottom of the form.

 

[Van T. Dinh]

In the Form_Load Event, use the GoToRecord Method of the DoCmd object to go
to the last Record.

Check Access VB Help on the GoToRecord Method.

 

[Jeff Boyce]

Nick

Are you quite certain that what YOU consider to be the "Last Record" is how
ACCESS views it?

Are you saying you want the form to open "knowing" what the last-input
record was? If so, Allen Browne has some tips that may help:

http://allenbrowne.com/tips.html

Good luck

Jeff Boyce
<Access MVP>

 

[Guest]

Thanks, It works when I open it independatly on open but if it is a sub form
I get an error message.
"Macro contains a gotorecord but the object name arguement name an object
that is closed"

 

[Van T. Dinh]

Are you using Macro or VBA?

If you use Macros, you need to use the GoToControl action before the
GoToRecord action.

Read the Help topic on GoToControl carefully. The Tip in the Help actually
talks about Subform.

 

[Guest]

I am using a Macro and did read the help tip, but I am afraid I'm not
grasping the directions. Please help me. the form AMSRoutes with a subform
of AMShistory with field name of [ActionId], [ActionDAte], and [AddNotes] and
I want to see the last [ActionDAte].
Thanks