Hi Guys

I am using VBA.
I have created a form with a subform in it and they are both liked with a suplier number.
My problem is that I want to export to a text file using a botton. I want the information on the text file in this format.

The first line to be suplier number from the parent table. The second line to be the invoices from the child table which is my subform.

I have tried using the write and TransfareText method but have not succeded if you have any idea please assist.

Thanx a million.