loop to run a macro for each value

[blutimus]

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

 

[PHV]

Convert the macro to VBA and browse the form's recordset.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[blutimus]

hi

thanks for the reply and suggestion.

i neglected to mention (sorry) i'm not too hip with the programming... how do i do that?

b

 

[HitechUser]

blutimus,

To convert consult help text

or this...

http://msdn.microsoft.com/library/d...ff2000/html/achowConvertMacrosFormReportS.asp

...

 

[blutimus]

wow, that was easy.

now how do i 'browse the form's recordset'?

thanks for the prompt effective reply.

blute

 

[HitechUser]

blutimus,

Look at Zion7's Dec 21 reply at this link..

http://www.tek-tips.com/viewthread.cfm?qid=971157&page=1

That is a simple example. You will need to insert your converted VB (from macro) in the loop (of course your table names, etc. etc. etc.).

Just trying to point you in the right direction.

I hope this helps..

Good Luck...

 

[PHV]

now how do i 'browse the form's recordset'
Do a keyword search in this forum for browse recordset or browsing recordset.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244