<div>
<div class="content wysiwyg-content">
I have a form displaying in datasheet view. &nbsp; The records are sorted by [ID] DESC.<br />
<br />
My question is... is there a way to lock all but the top record so the user can only open the top record via the ID field which I have set as a hyperlink? &nbsp;In other words, let them open the records single view form ONLY if it is the top record.
</div>
</div>


I have a form displaying in datasheet view.   The records are sorted by [ID] DESC.

My question is... is there a way to lock all but the top record so the user can only open the top record via the ID field which I have set as a hyperlink?  In other words, let them open the records single view form ONLY if it is the top record.

Lock all but the top record in a datasheet view 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.