Victor, Is one of these formulas assigned to field P3F3 itself? If so, what may be happening is that the formula gets processed multiple times because each time it changes the value of P3F3 that triggers it to apply the formula again.
Also, when is the field set to update: Create, Save, or Any Change? Tim Rude ----- Original Message ----- From: "Victor Warner" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, August 16, 2006 9:03 AM Subject: [Dataperf] Problem with CASE statement I am having problems with the CASE statement. In the following: P3F3 CASES CASE CV ="A" OF "Apostille" ENDOF CASE CV ="C" OF "Certificate of Good Standing" ENDOF CASE CV ="D" OF "Print off documents at Companies House" ENDOF CASE CV ="L" OF "Legalisation service provided by agent" ENDOF CASE CV ="O" OF "Basic internet available info from Companies House" ENDOF CASE CV ="R" OF "Recorded Mail" ENDOF CASE CV ="X" OF "Other legalisation" ENDOF DEFAULT "" ENDCASES when I enter "L" or "C", the corersponding text shows in the field, but if I tab to the next field or save, the corresponding text disappears. also in the following CASE statement: P3F3 CASES CASE CV ="S" OF "Statute" ENDOF CASE CV ="I" OF "Statutory Instrument" ENDOF DEFAULT "" ENDCASES entering "I" produces the text for "S". Help with this would be very gratefully received. Victor Warner _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
