Use Previous Fields Value For New Records

[razorking]

I have a form with two fields: Location and serial#
I would like to find a way to automatically populate the new records with the location value from the previous record. What I mean is; the location field will typically be the same for many consecutive records. So I do not want the user to have to enter a value there for every record. However, it will change, so I just want to have to key a value there when it does change and then have it use the previous field value, again, repeatedly, until it is manually keyed with a new value.

Hope I am making myself understood. I have attached a sample database. If anyone has a good method of accomplishing this and would like to add the functionality to the attached and re-attach, I would greatly appreciate it.

Thanks!

 

[boblarson]

check out my post here (all the way to the bottom) for a sample
http://www.access-programmers.co.uk/forums/showthread.php?t=119672&highlight=default

 

[missinglinq]

Actually, Access has already done this for you! Once the Location control has focus (you'd probably want it to be the first control to have focus) the user simply presses and holds down the <Control> key then presses the <Apostrophe> key! The field will be filled with the value from the previous revord! The only caveat is that you have to make sure that the form isn't requeried until after you've entered all the records you want for a given location.

 

[razorking]

I could not make use of either of your suggestions.

I am already aware of missinglinq sugggestion of using <Control> key then presses the <Apostrophe> key. But I don't want that because I am entering data into the serial# field using a scanner. I don't want the user to have to do the CTRL+APOSTROPHE for each location record. I just need it to auto fill until it is changed.

And I was not able to get boblarson's database example to work...maybe I am understanding what he was doing or he misunderstood what I want, I don't know, just can't get it to work.

Here is link explaining what I do want - in case anyone else needs this:
http://support.microsoft.com/kb/210236

I was able to make this work on my example database and I am including that in hopes that it might save someone else some hair on their head.