The Radio Group control will handle this for you automatically. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Monday, August 13, 2012 10:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Computed Column for UPS and FedX
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. >
