TransferText File Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here's my dilemma:

I have a query that I need to ouput to a text file. I've gotten that much
to work using the transfertext action in a macro. Now, I would like for the
transfertext action to pick up a piece of data from the form to use in the
name of the file.

For instance:

An index is entered as 03-372. The query returns the records associated
with that index and the macro outputs that data to a text file. I want the
text file to be %my path%\03-372.txt.

Any suggestions?
 
Use an expression in the File Name argument of the macro:

="C:\TheFolder\" & Forms!FormName!TextBoxName & ".txt"
 
That's it. I tried that before, but either I forgot the equal sign or I had
incorrect syntax in the Forms!... call. Thanks for the help.
 
Back
Top