Firstly, may I say you should check out the Sticky threads at the head of the forum before posting any more questions. I will tidy this up for you this time, but even then it is short of much important information.
What you need to do is place some code in the
Form_Current() event procedure of your form that checks the date control for the criteria (that you haven't specified in your question). You must set the form's
.AllowEdits property regardless of your check, but the check determines which way to set it. This is because an earlier record may have left it in a state that you cannot predict.
As it's a boolean property, you can simply set it to the result of your check. EG. :
- Me.AllowEdits = IsNull(Me.DateControl)
To help with a solution regarding allowing some people to override this I will need more clear information about what you have in mind. Generally, such things would be better handled at a central level rather than on each form that requires it (otherwise the interface is painful). Using the Network ID is often a good way of minimizing the operator overhead.