Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Forms > Make Fields Rea...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 44641 of 46475
Post > Topic >>

Make Fields Read Only After Update is Made to Another Field

by =?Utf-8?B?Sk1C?= <JMB@[EMAIL PROTECTED] > Aug 6, 2008 at 05:35 PM

When a field is updated with a value of "approved" can that field become 
"read-only" as well as other subsequent fields, so that users cannot
change 
the values once they have been approved?

For example:  A status field is set to Approved (from a drop down list) 
after the estimated hours have been filled in 4 other fields. I need the 
status field as well as the estimated hours fields to become locked or
read 
only so users cannot change the values.

I do not know SQL, so will need precise instructions on how to accomplish 
this.
THANKS!!
-- 
JMB
 




 4 Posts in Topic:
Make Fields Read Only After Update is Made to Another Field
=?Utf-8?B?Sk1C?= <JMB@  2008-08-06 17:35:01 
Re: Make Fields Read Only After Update is Made to Another Field
"Jim Bunton" &l  2008-08-07 03:39:15 
Re: Make Fields Read Only After Update is Made to Another Field
=?Utf-8?B?Sk1C?= <JMB@  2008-08-07 05:56:02 
Re: Make Fields Read Only After Update is Made to Another Field
=?Utf-8?B?Sk1C?= <JMB@  2008-08-11 12:18:24 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 20:40:54 CST 2008.