I have two tables:

1 to many relationship

So order number 1 may have 3 sales lines A, B and C

I can show this info in a form by showing the tblOrderDetails part in a sub form.

My problem is that I am using a command button to send info to an e-mail using:

I can get it to show Order 1 with line A but how do I get lines B and C onto the mail?

DoCmd.SendObject , , , "test@abc.co.uk", , , "Order Number: ", Me.OrderNumber, Me.OrderLine