James: Most data integrity is best performed using filters. If you're using a basic character menu, then you could build a pair of filters; the first one would see if the current Status value is in a string like "Open, Pending, Closed" (list all your allowed statuses), and the second filter would present an error if the Status value was not found in the string. If you ever add a status value in the future, then you'll have to remember to update the list of allowed values in the first filter.
HTH, --Phil ----- Original Message ---- From: James Collins <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, January 16, 2008 5:55:55 PM Subject: Force Users to Use Update Button I have a form, that has a status field. It gets updated by a button that pulls up a menu of status. People keep free forming in the status field which screws up the status etc., I changed the permissions of the field but that does not allow the users to update with the update button. My other thought was to run an active link that triggers an error on gain focus. Which works, however, i am not sure it is the correct method. I just do not want to see in my status field missppelled statuses like Klosed or ClOsed or whatever, any helpful hints? James _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
