I was wondering if its possible to lock records in a table given a field meets a certain criteria. For instance, at work, we have a trouble ticket database. Once the ticket status is updated to "Close", I dont want anyone to change anything for that particular record (other than the admin if need be). Now the permissions for the table have already been set. A user can do everything but delete records. I have to give them the ability to update because users come back to the record to add more information. I'm trying avoid users changing recordsets once the ticket is closed. I have tons of vba coding done for this database (used on the forms), so if theres something I can add, I'd like to know as well. Thanks guys for any help..