Hello, I am developing a payroll and record keeping database for my office and I am learning Access as I go.
I have designed a data entry form where where the user will enter information from an employee's time-sheet. I have a 'DateWorked' field and generally we are entering 50-70 records for everyday. To eliminate the repetitive task of re-entering the same date for all 50-70 records I want to design the form to auto-fill the 'DateWorked' field based on the last entry. This way the user will only have to enter/change the 'DateWorked' date when they begin entering records for the next day.
I have come across this solution: http://access.mvps.org/access/forms/frm0012.htm by Dev Ashish but I have not had any luck with it and feel like I need someone to explain it more thoroughly (like as if I were a 5 year old).
Thanks!