Need Help Assigning File Name

[Stryker22150]

I need help with assigning a file name, based on a value in a field.
The same query supports 3 different reports. The file is exported as a
delimited text file. I would like to assign a file name based on a
field value.

TIA

 

[[MVP] S.Clark]

To reference a control on a form, use the syntax:

Forms!Formname!controlname

 

[Stryker22150]

Steve;

Thank you for the response; however, that was not what I was looking
for. I have a parameter query that supports 4 different reports. Each
of the reporrts has a seperate file name. When the rotine runs I would
like to be able to dump the file with a name associated to the
parameter value.

An example if <field_name> is =2 then SaveAs ABC.txt or If <field_name>
=3 then SaveAs XYZ.txt

TIA