hello
i hve a macro 'macro1' which i normally call from a form. the form passes a value 'cust_id' from the customer table. the macro runs several queries which use cust_id as a parameter, makes a table with the results, then calls a function which transfers the table to a spreadsheet. then i go back to the form and enter a new cust_id, and run the macro again until i have a spreadsheet for every cust_id. how do i run the macro once for each cust_id in the customer table?
i appreciate any ideas.
blute
i hve a macro 'macro1' which i normally call from a form. the form passes a value 'cust_id' from the customer table. the macro runs several queries which use cust_id as a parameter, makes a table with the results, then calls a function which transfers the table to a spreadsheet. then i go back to the form and enter a new cust_id, and run the macro again until i have a spreadsheet for every cust_id. how do i run the macro once for each cust_id in the customer table?
i appreciate any ideas.
blute