checkbox valuelist to comma text box

[micintosh]

I have a checkbox value list and what I need are the values selected put into another field on one line separated by commas. I know about the Substitue script, but I need this automated so as soon as the user selects the values, the values automatically appear in the 2nd field. How would I go about doing this???

[LaRetta]

Hi micintosh,

Establish an auto-enter on your second field via calculation. Be sure to unclick 'Do not Replace Existing Values' right under the calculation box. Then your field will constantly update as the checkbox changes. Calculation would be:

Substitute(textfield;

[micintosh]

I can get the Field2=Field1 calculation in Field 2 to autolookup the values in the Field1 checkbox value list, but can't get the Substitue calculation to work in the same calculation in Field 2. How is this done?

FYI: Field 1 is a checkbox valuelist

Field 2 is an Edit box

and I am using FMPro 7

[LaRetta]

If you have applied a calculation to Field 1 (checkbox), then I haven't explained myself well enough ...

The calculation should be applied only to Field 2 and Field 2 must be a separate field - not just a copy of Field 1 and it shouldn't have a value list attached to it. Is that what you mean when you said Field 2 was an 'Edit Box'? I have attached an example. Is this not what you requested? If not, we will try again.

If this doesn't do it for you, let us know what else you may need.

LaRetta

CheckBxList.zip

[micintosh]

Perfect! Perfect!! Perfect!!! Thank you so much for your help!!!