hello
i currently use a form with a dropdown list to choose a customer, then hit 'go' on the form to run a macro which opens a make table query then runs a module to export it to excel. the customer comes from a table.
i would like to figure out how to run the macro for each customer in the table using a loop, instead of one at a time as i do now.
can this be done without modifying my module, macro and form... so the current method is still an option?
please be explicit, i am a novice at this.\
thanks
blute
i currently use a form with a dropdown list to choose a customer, then hit 'go' on the form to run a macro which opens a make table query then runs a module to export it to excel. the customer comes from a table.
i would like to figure out how to run the macro for each customer in the table using a loop, instead of one at a time as i do now.
can this be done without modifying my module, macro and form... so the current method is still an option?
please be explicit, i am a novice at this.\
thanks
blute