Autofill a checkbox to lock a Record in a Form

[Confused Newbie]

Hey there Gang,

I am in need of some assistance. Ok here is my scenario. I have a Form (Query) that will have multiple users editing information in a Table at the same time. I need the reps to be able to work the records in consecutive order with out "stepping on each other". So my thought was to create a check box that the would auto populate when when someone entered into a record. And UnCheck itself when they either press a save button or exit the record. I would then set the the Next Record button to take the user to the Next record that was unchecked. Does this sound feasible?

Next how do I get the check box to Auto Populate (Check Itself) and then Uncheck itself on clicking on the save. I have searched high and low for this peice of code everywhere.

Thanks for any help you can give me...

Randy

[puppydogbuddy]

There is no reason to have a checkbox if you already have a save button or other buttons that you can disable or enable depending on whether the record is being edited or not.

How you determine whether the current record is being edited can be determined from the status of the EditRecord Flag, which would have to be programmed to auto set/unset as detailed the following link from Microsoft KB:
http://support.microsoft.com/kb/122294

For a great step by step how to implement this, see the following link (you need to read the entire link, but the final coding solution is in the last post of the link):
http://www.tek-tips.com/viewthread.cfm?qid=835483

Note that in order for the above code to work effectively in a multi-user environment, Access should have the following locking scheme settings (Go To Tools>Options>Advanced on the Command Menu):

Default open mode = Shared
Default record locking = Edited Record
Checked Open databases using record-level locking

Hope this helps.