dtwow98 said:
How to allow users to edit only certain records in access 2002.
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
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
