access to text file

[mk sabeel]

hello sir,

Thanks in advance for the help

I filter a form which is based on 3 tables then
i get around 20 records.how do i open the filtered records
as a recordset in the VBA. plz give me the syntax.

also how do i write a text file linewise in code using the
Print statement, as what i want to achieve is that
i want to output the form to a text in such a way that the
feilds of the form appear in the text file one below the
other like-
RECORD 1
feild name feild value
feild name feild value
feild name feild value

RECORD 2
feild name feild value
feild name feild value
feild name feild value
'
'
'
RECORD 3
feild name feild value
feild name feild value
feild name feild value

i want the text file to read show the filtered records in
the above format.
plz tell me how do i go abt this

thank you
mk sabeel
(e-mail address removed)