Hi all - I do appologise for this post as I know the answer is out there
somewhere. I printed it out a few weeks ago - just can't find the printout. I
have spent the last 10 minutes searching but can't find it so here goes.

I need the code (something like me.current = me.????) to put the previous
records' data into a field.

Thanks in advance and sorry.

Dika (Kernow Girl)

Use the AfterUpdate event of the control to set its Default Value.

Details:

http://www.mvps.org/access/forms/frm0012.htm



An alternative approach is to use the BeforeInsert event of the form to copy
the values from the last record:

http://allenbrowne.com/ser-24.html


--
Rick B



"Kernow Girl" <(E-Mail Removed)> wrote in message
news:7DBD3547-F14C-459F-B03E-(E-Mail Removed)...
> Hi all - I do appologise for this post as I know the answer is out there
> somewhere. I printed it out a few weeks ago - just can't find the
> printout. I
> have spent the last 10 minutes searching but can't find it so here goes.
>
> I need the code (something like me.current = me.????) to put the previous
> records' data into a field.
>
> Thanks in advance and sorry.
>
> Dika (Kernow Girl)

Thanks Rick, I'll try not to lose it again. Dika

"Rick B" wrote:

> Use the AfterUpdate event of the control to set its Default Value.
>
> Details:
>
> http://www.mvps.org/access/forms/frm0012.htm
>
>
>
> An alternative approach is to use the BeforeInsert event of the form to copy
> the values from the last record:
>
> http://allenbrowne.com/ser-24.html
>
>
> --
> Rick B
>
>
>
> "Kernow Girl" <(E-Mail Removed)> wrote in message
> news:7DBD3547-F14C-459F-B03E-(E-Mail Removed)...
> > Hi all - I do appologise for this post as I know the answer is out there
> > somewhere. I printed it out a few weeks ago - just can't find the
> > printout. I
> > have spent the last 10 minutes searching but can't find it so here goes.
> >
> > I need the code (something like me.current = me.????) to put the previous
> > records' data into a field.
> >
> > Thanks in advance and sorry.
> >
> > Dika (Kernow Girl)
>
>
>