November 27, 200124 yr I want to create my own "Find Form" to validate some fields before submitting them in the actual Find layout... After validation, I'm not sure how to transfer the user input from the fields on my form to the actual fields to find. The user could perform a find on various fields: Date, 1stName, LastName, Dept, JobTitle. Is it best to use a loop and copy/paste each field to the find layout? Is there a better way, what is the difference between Set field, Insert Calculated... and Paste?? Thanks for the help --Dan
November 27, 200124 yr quote: Originally posted by DannyA: After validation, I'm not sure how to transfer the user input from the fields on my form to the actual fields to find. The user could perform a find on various fields: Date, 1stName, LastName, Dept, JobTitle. Is it best to use a loop and copy/paste each field to the find layout? Is there a better way, what is the difference between Set field, Insert Calculated... and Paste?? I'd be inclined to create corresponding global fields for each of the fields you'd be searching. In the script I would enter Find mode, use Set Field to set the search fields to the values contained in the global fields, and then Perform Find. Set Field has an advantage over the other options in that the field specified does not have to be on the current layout, plus Set Field will not replace the contents of the clipboard, which may just contain information the user wants to keep in there. Hope this helps.
November 28, 200124 yr One addendum -- after performing the find, have the script also clear all the global fields. That way, they'll be blank for the next find.
Create an account or sign in to comment