Lock all but the top record in a datasheet view form

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.
SteveL13Asked:
Who is Participating?
 
Gustav BrockCIOCommented:
Yes:

If Me.CurrentRecord = 1 Then
    ' Allow open form.
Else
    ' no.
End If

/gustav
0
 
SteveL13Author Commented:
Perfect again!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.