In forms, where only two answers are possible, I generally use a check
box. For Open or Closed, the checked value would be "C" and the
unchecked value "O". I find this eliminates any possibility of user
creativity. In that field, anyway. I did create one form where there
were three check boxes and checking any one unchecked the other two
using an On Click eep. .
Albert
On 13/08/2012 8:54 AM, Kenny Camp wrote:
Thanks,
My new code (in 14 forms so far) handles this well and we are live this
morning. Sometimes it's hard to see the forest for all the trees.
Kenny
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Javier
Valencia
Sent: Friday, August 10, 2012 6:34 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Computed Column for UPS and FedX
Kenny,
I ran into similar problem a while back, where users were supposed to enter
"O" or "C" for open or closed status of work orders, but they decided to
create their own codes such as "H" for hold, "I" for in-progress and so on,
even when there was another field to do just that...users tend to do that.
This created a problem because reporting was based on work orders being
either open or closed. I modified all data entry form so only the two option
are available; if they enter a value other than "O" or "C" the values is
reset to "O" and a warning message is displayed. We have not had a problem
since then.
