Re: Last record entered

Put a SORT DESCENDING on the QUERY or SQLStatement used for the form's recordsource

GeorgeF wrote:
I have an Access 2003 table to collect labor hours by employee number and a form to interact with the table. It would be useful to open the form with the data from the last record entered chronologically. I tried using Dlast as a default value for employee number but it returns a seemingly random record rather than last entered. The table includes a date field and a unique autonumber field so it knows the last record. I just don't know how to retrieve it.

Thanks 
.