Export table/query - two lines per record w/ different specs?

[manito2000]

Hello everyone,

I have two tables that need to be exported on one .txt file.

One table has the header record. And the 2nd table has the detail record.

My issue is as follows:
1. Need to create one .txt file
2. The header record has one set of export specs and the detail record has a different set of export specs.
3. The first line is the header record, and 2nd line is the detail record.

Hope the example below helps:

H Abraham Armenta January Cake 00123
D Father Saturday 02536 00123

Both tables have a common control number - in this case represented by the 00123. I just cannot figure out how to accomplish this..

 

[llkhoutx]

Use 2 successive "docmd.transfertext" command lines.

 

[JHB]

Use 2 successive "docmd.transfertext" command lines.

Could you please show some working code for that, (not some "air" code, but really working code)?