<div>
Remember that a table really does not have a &quot;last&quot; record.<br />
A table can be sorted in any order, so the &quot;last&quot; record can change.<br />
<br />
If you mean the most &quot;recent&quot; record, then you can add a &quot;created date&quot; field to your table and add in the current date time.<br />
The sort a query of this table by this date field, ...then do as etsherman suggests above...
</div>


Remember that a table really does not have a "last" record.
A table can be sorted in any order, so the "last" record can change.

If you mean the most "recent" record, then you can add a "created date" field to your table and add in the current date time.
The sort a query of this table by this date field, ...then do as etsherman suggests above...

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have an Access form where I want to lock the last record to keep people from editing it, but the other records are ok to edit. &nbsp;Is that possible?<br />
<br />
Thanks, Joel
</div>
</div>


Hello,

I have an Access form where I want to lock the last record to keep people from editing it, but the other records are ok to edit.  Is that possible?

Thanks, Joel

MS Access 2010 lock record in form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.