Running a string of queries into 1 macro

[naomi]

Hi,

I have created 10 queries and now I am stumped on the next thing to do.

What every query has in common is it prompts for a customer number. i have to do all 10 queries in order and for the same customer. I know how to put all the queries in one macro, but I dont want to answer the parameter [please enter customer number] for every query. Iam trying to make this useful to use with 100's of customers, so can you tell me how i can just specify the parameter once and it will use it for the other 9 queries?

I thought I saw this done before, but now I'm not so sure.

Please help!!

 

[Mile-O]

Let the queries reference the value on a form.


ie. as a criteria on the customer field:

[Forms]![frmYourForm]![txtYourTextbox]

 

[naomi]

it worked!!

Thanks Bunches!!!! It Worked Perfectly!!!