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

Check box for locking

P: 2
I am attempting to create a check box that when made "yes" locks the form from all other editing. I do still need to create new forms within the data base. Does anybody know how to do this or even if its possible, even a button that will do it rather than the check box would be welcome. My access knowledge is very limited. I got the project by been the person with the least work load. Thanks.
Jan 9 '07 #1
Share this Question
Share on Google+
4 Replies


PEB
Expert 100+
P: 1,418
PEB
U need the form locked for editing and the user that uses the form can't introduce any info anywhere?

Or simply when user introduces record other can't do anything on this record?
Jan 9 '07 #2

P: 2
U need the form locked for editing and the user that uses the form can't introduce any info anywhere?

Or simply when user introduces record other can't do anything on this record?
A user creates a form. Any number of users may view and some may edit the form. The form is for work status, so further entries may be made untill the job is complete. Once the "job complete" box is checked I want the form to be locked so no further entries can be made on that form.
Jan 9 '07 #3

PEB
Expert 100+
P: 1,418
PEB
A user creates a form. Any number of users may view and some may edit the form. The form is for work status, so further entries may be made untill the job is complete. Once the "job complete" box is checked I want the form to be locked so no further entries can be made on that form.
In this case in ur form u need a bit VB

In Form properties go in Current, choose event procedure and type

Expand|Select|Wrap|Line Numbers
  1. If me!FIeld1=Yes then
  2. Me.AllowEdits = Yes
  3. else
  4. Me.AllowEdits = no
  5. end if
  6.  
me!FIeld1 is the name of ur respective field that is filled with Yes or No

I assume that Yes or No is a checkbox and not textfield!
Jan 9 '07 #4

NeoPa
Expert Mod 15k+
P: 31,186
Vladi,
You have too much code there ;)
Expand|Select|Wrap|Line Numbers
  1. Me.AllowEdits = Me.chkJobComplete
It will work, of course, but you will not be able to un-check it afterwards as this disables even updating of the Job Complete checkbox itself.
Jan 9 '07 #5

Post your reply

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