I want to create a text file with a name which is the same as a field name
and print to that file based on the contents of that field. I would like to
do this with a subroutine call.

there are fields in a table A, B, C etc. (all are boolean).

I want to write a text file

call subx("A")

Private subx(S as string)
Open "c:\XXX\" & S & ".TXT" For Output As #1 ' no problem with this
with....
while...
....
If !S = true then.....
....
wend
end with
Obviously this doesn't work; can I do something like this somehow?

Dick