When the User has only Insert authority on the table he cannot be allowed to edit selective fields on the Form. If he has edit authority on the table then on the Form we can identify the current User and lock all the fields while opening the form through VBA.
If he is trying to create a new record (current event) then unlock all the fields for data entry and lock all the fields on the update event.
On Click Event of Status and Close Date, unlock the fields for editing and lock again on the update event.
If you have several Users of this kind then you may create a Group Account for them and assign permissions on the Group Account rather than for each User.
Current User's Group Name can be checked with statement like:
Code:
IF dbengine.Workspaces(0).Users(currentuser).Groups(0).Name = "NoEditgrp" then
'Rest of the procedure
End If
http://www.msaccesstips.com/2010/03/...ount-with-vba/
http://www.msaccesstips.com/2006/11/...cess-security/