Disallow Edits after Record Closed / Saved

[Ally]

I have been asked by two separate database users about this as they've both been having problems with some users going in and changing data later.

Does anyone have any ideas on how to do this. The thing is, it won't be the whole form - because on both dbs, some information is entered to begin with, then some a bit later, therefore it would have to be for those records which are not null!

I hope this makes sense. I'm presuming it'll have to be something along the lines of AllowEdits but wondered if anyone else had done anything similar. I do already have AllowEdits code (in a module) for all the forms depending on the users user-level.

 

[Rich]

You can use a For each loop and the Tag property to enable/disable various fields dependant on your conditions

 

[Ally]

Thanks Rich - will have a go.