Sorry, I forgot to mention that I have been getting errors with this.

When a user attempts to update a record that another user is viewing then I get the "Record is Locked" or "Record in Use" message.

Does that make sense?
Thanks