By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 904 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Autofill a checkbox to lock a Record in a Form

P: 1
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
May 17 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
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.
May 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.