Shared form nedd help locking

[Jon123]

I have a form that is a checklist that users will share until the checklist is complete. So a user will start filling out the checklist at the end of their shift they save it. The next shift opens it how can I have the data entered from the previous user secure so that additional users cant change what was entered but yet the next user and continue entering or adding to the checklist?

jon

 

[evanscamman]

If your form doesn't use check boxes you could do it this way:

MyControl.Locked = not isnull(MyControl)

Do this for each control in the OnLoad event of your form.
This locks the control if data has been entered into it.

Potential problems:

• You have to ensure that the form gets closed and reopened at the start of each shift.
• Checkboxes are False by default - not null. Perhaps you could solve this by using tri-state checkboxes (I have never messed with them, so I don't know if it would work.)

Hope this helps,
Evan