Sure, but only from forms. If a user can get to a table or query, there's no
way to do it on a row-level basis. First you'll need a mechanism to identify
your user, or perhaps it doesn't matter who the user is, you may have
another criteria, such as an assigned date. Here's a snippet of sample code
(air code ... not debugged)
Sub Form_Current()
If Len(Me.txtAssigned & vbNullString) > 0 Then
Me.AllowEdits = False
Else
Me.AllowEdits = True
End If
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
