See:
Assign default values from the last record
at:
http://allenbrowne.com/ser-24.html
The code is very easy to implement. (It's a bit lengthy because it has to
figure out which controls to copy, and which ones not to, but you just
copy'n'paste it.)

Signature
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.
> Hello,
>
[quoted text clipped - 15 lines]
>
> Thanks!!!!
Stockwell43 - 28 Mar 2007 12:52 GMT
Excellent, thanks Allen you're always a big help!!!
> See:
> Assign default values from the last record
[quoted text clipped - 24 lines]
> >
> > Thanks!!!!