Looping VBA

[quixote]

Looking for proper syntax for a loop in a loop vba.

I have a table with Job information and another table related to it with
order information. I am looking for a way to loop through all jobs and then
list the orders for each job. I am actually going to print this info to an
email, here is an example of what I would like:



Job 100

Order 1 Order Desc
Order 2 Order Desc
Order 3 Order Desc



Thanks

 

[Treebeard]

Do you want to loop through the entire Job-Order query, or just certain
Jobs?

 

[quixote]

I want to loop through each job and put the job number and all associated
Orders with that job in a seperate email, the email part I can do, I always
get my wires crossed when it comes to looping through a recordset though. The
purpose is to notify relevant associates about outstanding orders to be
processed. I could do this on an individual basis, but I would like to do it
all at once.

Thanks

 

[Albert D. Kallal]

You don't need to loop here. All you do is create a report, and drop in a
sub-report for the details.