Record locking on a shared form

[Paintballlovr]

I'm not sure if/how to do this, but here's what I'm looking to do. I have a continous form that displays basic open ticket information and a button to open another form to work the ticket. All users go through the same forms, they just have their own worklists. What I want to do is when operator 1 opens a ticket, that record gets locked in the table, but other operators and use the same form to open other records. the idea is all of the operators can be using the form at the same time, but no two operators can be in the same record at the same time. Hopefully that's not too muddied of a description.

[ItsMe]

You can lock records using DAO Recordsets. Not sure how that would affect your user's experience with the form though.

[Paintballlovr]

Not sure how to do that or what it would look like. I think the operators will just reassign tickets, so there is no overlap. Thanks for the quick response though!