Make previous entry the default for the new record

[Gambit17]

Hi, I am busy setting up a Access database for disadvantaged farmers in Africa and I could use some help. The Data is all in paper form at the moment and there are about 10 000 farmers that we need to convert to electronic form.

I am going to be using a form to do this, in order to make filling out the form more efficient I would like to make some fields stay the same to the last entered value. Is this possible?



Many Thanks
Gambit

[pbaldy]

One way:

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

[Gambit17]

Thanks Pbaldy. Where should I paste that code? Sorry I am very new to Access?

[pbaldy]

I would probably use the after update event of the control (textbox):

http://www.baldyweb.com/FirstVBA.htm

[Secue]

Hi:

I have similar probelm, I want to populate a form with information from the previous record, I tried witht he recoemndation from Gambit17, but it did not work for me, maybe I did something wrong.

[pbaldy]

You'll probably get your answer here:

https://www.accessforums.net/forms/n...ata-36523.html

[Secue]

Hey:

So far I was able to solve my problema using funtion DLast.

Details on http://www.techonthenet.com/access/f...main/dlast.php

[Gambit17]

Thank you so much, it worked. Thanks Secue and pbaldy