I am working on a database for my boss that stores the results of monthly file audits and generates reports.
Each month about fifty files are checked against a check list and the results are to be entered into the database. Reports are generated quarterly.
I have a date field that holds the date of the review. I would like the default value of this field to be what ever was entered in the previous record. That way this field can be tabbed through until the next month. When the data in the field is changed that will become the new default for the following records.
I don't have any formal VB or VBA training. I just learn what I need for each project and save it for later use.

Thank you for any help you can provide.

Henry L Michel

Check out this sample for something similar to what you are wanting. I created this for a different post.
http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=15884&d=1166902849

Thank's for your help. Unfortunately, I was never able to get it to work for me.
I ended up getting a module from microsoft's knowledge base that I was able to get working after a while.