Assign the value from the most reccent record in the form's BeforeInsert
event as described he
http://members.iinet.net.au/~allenbrowne/ser-24.html

Or set the Default Value of the controls in their AfterUpdate event as
described he
http://www.mvps.org/access/forms/frm0012.htm
--
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.

"A.K" wrote in message
news
Easy to key data in the next times for some information is same that
information no need to key again.