How I can start last edited record in my form?

How I can start last edited record in my form?

am 06.01.2008 02:44:09 von SoulSeeker

Hello.

How I can start my M$ access form with last edited record? What I must put
in "on load" field?

Tnx. for advice.

Re: How I can start last edited record in my form?

am 06.01.2008 02:46:58 von SoulSeeker

I have access 2003. Tnx.

Re: How I can start last edited record in my form?

am 06.01.2008 06:18:35 von Allen Browne

See:
Return to the same record next time form is opened
at:
http://allenbrowne.com/ser-18.html

--
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.

"SoulSeeker" wrote in message
news:flpbuj$iun$1@aioe.org...
>I have access 2003. Tnx.

Re: How I can start last edited record in my form?

am 06.01.2008 10:40:59 von SoulSeeker

"Allen Browne" wrote:

Msg ID: news:478064b1$0$11956$5a62ac22@per-qv1-newsreader-01.iinet.n et.au...

> See:
> Return to the same record next time form is opened
> at:
> http://allenbrowne.com/ser-18.html

Thank you very much Allen. Have a nice day. :)

Re: How I can start last edited record in my form?

am 08.01.2008 20:28:51 von frogsteaks

On Jan 6, 4:40=A0am, "SoulSeeker" wrote:
> "Allen Browne" wrote:
>
> Msg ID:news:478064b1$0$11956$5a62ac22@per-qv1-newsreader-01.iine t.net.au..=
..
>
> > See:
> > =A0 =A0Return to the same record next time form is opened
> > at:
> > =A0 =A0http://allenbrowne.com/ser-18.html
>
> Thank you very much Allen. Have a nice day. :)

This can be modified to save the last edited record on a per user
basis by adding the appropriate user identifier to the tblSys table.
Can be handy in a multi-user environment.