Collating subform data

[davesmith202]

I have tblClients and tblOrders, with a Main and Subform accordingly. I would like to click a button when on a particular client record and then this will create a list of items ordered with the order status set to Not Sent and put them into a memo field on the main form.

Output to memo field would look like this:

Dog food
Cat food
Dog collar
Dog chain

Fields are...

Main form:

ClientName

Subform:

Item
Status

Any ideas on how to do this?

Thanks,

Dave