Variuse FileName When Export

[shay]

Hi,
I'm using the DoCmd.TransferText action, but i'd like that the file name will be a variuse from a table,
something like:
AString = "[SingleOrdNumber]![OrdNum]"
DoCmd.TransferText acExportDelim, "ExportStyle", "OrdExportTable", "c:\hash\" & AString & ".ord"


The "AString" value is a value that is in a field called "OrdNum" within a table called"SingleOrdNumber".

Does not working.

Any Idea ?
Thanks

[TheShabz]

have you opened a recordset of SingleOrdNumber? I dont think you can do that unless you've opened the rs. Try using Dlookup instead.