"Eval" is your friend. Look it up in the Help file.
-Tom.
Quote:
>Hi, I'm trying to set up a generic mechanism that would allow the
>following:
>
>1: Run <this_procedure>
>2: After that, run <this_review_procedure>
>3: If it returns non-zero, open <this_form>
>
>The idea is that the first procedure would have to update records.
>After that, the review procedure would check if there are unupdated
>records. If there are, a form would open to show the problem records,
>for user review.
>
>So I would need to store in a metadata table: the procedure name, the
>review procedure name and the form name, for example:
>
>"update_yesterday_sales",
>"check_for_unupdated_sales",
>"frmShow_unupdated_sales"
>
>"update_repaired_parts",
>"check_for_unrepaired_parts",
>"frmShow_unrepaired_parts"
>
>And I would have a generic process running thru the records of this
>table and running all defined processes in sequence. At some point,
>the idea is present the user with the processes list and let the user
>choose (checkboxes I hope) which processes s/he wants to run.
>
>My question: Is it possible to retrieve a form's name from a table and
>show the form? Ditto for retrieving a procedure name and executing it?
>Do you have any pointers and/or examples to show me?
>
>Very thankful in advance
>Regards,
>Chris
