Copy Values from one record to the next on

[Gasman]

I have Google on my phone. So if you do not want to listen to reason, here are the bullets.

Microsoft Access tips: Assign default values from the last record

How to have form in a Microsoft Access database automatically offer to the values of the last record, to avoid typing similar data again.

allenbrowne.com

 

[alexsoft]

Thanks to all people reacted on my thread. Finally i read a liitle bit of vba and manage to do it with a command button.
Thanks anyway