I am new to scriptmaking and I want to create a script that will change a field with a radio button, from "Yes", to "No".

then I would like to create a button that will perfom the script when pressed.

I guessing this might me pretty easy, but I'm having trouble.

Can anyone help?

RET

One script step should do it:

Set Field [Fieldname, "Case(Fieldname="Yes", "No", "Yes")]

Thanks so much.....that relly worked.

however I guess I was not too clear. I wanted to preform this script to all records, can you help me do that?

RET

Use the 'Replace' Script Step'along with the formula already given

quote:

---

Originally posted by Korky:

Use the 'Replace' Script Step'along with the formula already given

---

Applying the given calculation to multiple records will actually toggle the field value, i.e. will change Yes to No and No to Yes.

If you just want to change Yes to No and keep No as-is, then use the following:

Set Field [Fieldname, "Case(Fieldname="Yes", "No", Fieldname)"]

An alternative to the Replace command would be to loop through the found set and use Set Field. This way you can perform a Find for all records where Fieldname=Yes, just to make sure.

Oh, the possibilities.

thanks guys...that worked.

one more thing .....is their a good book to learn more about scripts?