I have a screen that shows the user a list of actions that they can run on a file. It's a form (off a query, off a table) that shows the action name and a checkbox. The checkbox defaults to Yes and they can uncheck whatever actions they don't want to run.
When they go to run the list of (checked) actions (mostly procedures that run append queries via SQL) there will be about 30 selections. What is the best way to link their list of 30 to the procedures in the VBA?
Originally I thought I would hide the procedure name in the list, move through the recordset, pull the procedure name off the table, and call it like a procedure using a variable name, but I got the error that you can't call procedures as a variable. Is there another way to do this?
I could do a case select but would have 30+ options.
What would be the simplest most efficient way to code this?
Thank you!
When they go to run the list of (checked) actions (mostly procedures that run append queries via SQL) there will be about 30 selections. What is the best way to link their list of 30 to the procedures in the VBA?
Originally I thought I would hide the procedure name in the list, move through the recordset, pull the procedure name off the table, and call it like a procedure using a variable name, but I got the error that you can't call procedures as a variable. Is there another way to do this?
I could do a case select but would have 30+ options.
What would be the simplest most efficient way to code this?
Thank you!
Comment