Lock records

[Exodus]

My company has asked for an issue tracking database with the requirements that if is someone is edditing records it locks that block down until that user is done. I don't have any idea how to do it. my db is set up this way.

tables
tblPolls
tblIssues

Querries
qryPolls
qryIssues
qryFindPollsByID
qryFindPollsbyName


Forms
FrmFindPolls
FrmSearchResultsbyId
FrmSearchResultsbyName
FrmIssueTrackingMain
FrmIssueTrackingSub

The Form Issue Tracking Main has the Sub form IssueTracking Sub
Here users enter the issues in the sub form. The forms are linked by Poll ID
Is there a way to lock all the records with the same pollid in the tbltblIssues. Also to check who is editing them at the time?

 

[Exodus]

I was afraid I was going to have to take the route with custom code.
Like you said you can lock the record deing edited but idf someone was also editing the same record it only prompts for over writting the changes. How would the users know what is the right option here?
I'm not sure about the purpose of locking the block. Maybe so we don't get unneccessary records? or Some one doesn't change some thing they are not suppose to.

The custom code what problems do you see arising from 20 users using this db.
How can I force them to unlock the records, maybe forcing all forms as popups so the have to close out the form and run the code on exit?

I also have a post on a multi column form if you help me with that to.