Setting default value for new entry as previous entry

[Kozbot]

Hello

My last question was answered very quickly and I am thankful for that.

If this question is too basic I am sorry. Is there a method of setting the default value for new entries to the same value as the previous entry?

For example, I have a quality control information table that stores QC data for different lot numbers. It is annoying to enter in the lot number and product code field over and over again if there are dozens of records per lot number. Is there a way for Access to easily display the previous entry as the default value?

Thank you!

 

[pbaldy]

Try this in the after update event of the control:

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