AnsweredAssumed Answered

Repeating Script help....

Question asked by DavidR on May 23, 2014
Latest reply on May 26, 2014 by DavidR

Title

Repeating Script help....

Post

     Hey,

     So in my database i have 2 address fields that can be fill in and a vacant for the return mail.. and i have a 3 script that copy the data from the selected address to the used for mailing address. the scripts look something like below for address 1 and 2 with slight variations while the vacant script clears all the fields. initially when a record is created it needs to run the use address 1 script on every record to fill in the mailing address.

     insert text (select, "address 1 to use", yes)
     clear (select, "address 2 to use")
     clear (select, "Vacant")
     copy (select, "adress 1")
     paste (select, "mailing address")
     go to field ("address 1")

     how would i modify the script below to go to next record and repeat the script until the end of the found set of records?

     Loop
     insert text (select, "address 1 to use", yes)
     clear (select, "address 2 to use")
     clear (select, "Vacant")
     copy (select, "adress 1")
     paste (select, "mailing address")
     go to field ("address 1")
     go to record (next)
     end loop

     this seems to work kinda... but the cycle never breaks unless i hit esc....

     THANK YOU!

      

Outcomes