Not sure how to do this, but I want to import a text file and base the file name on a text field in a form.

Text field is called txtInvControlnumber
Import spec is called ControlnumImportSpecification
Table to import into is T_ScannerImport

I want to select\enter my control number on the form and import the txt file that matches.

Here is what I have so far, but I can't get the variable to work.

Dim Ctrlnum As String
Ctrlnum = txtInvControlnumber

docmd.Transfertext acExportDelim,ControlnumImportSpecification,T_ScannerImport,"\\xxx01\act\InventoryControl\WIP\" & Ctrlnum & ".txt",No,,

I solved this and if anyone wants to know, it goes like this

Dim Ctrlnum As String
Ctrlnum = txtInvControlnumber
Dim fullnum as String
fullnum = "\\xxx01\act\InventoryControl\WIP\" & Ctrlnum  ".txt",No,,
docmd.Transfertext acExportDelim,"ControlnumImportSpecification", _
    "T_ScannerImport", fullcntrlnum, No