Hi,
I want the below vba to reference a text box in a form in this case "NameOfFile" and then when the below vba imports data instead of having "GPO_Data.csv" in the vba I can write the name of the file in the text box on the form and click update
DoCmd.TransferText acImportDelim, "GPO_Data_ Import_Specification", "GPO_CoreData", "Z:\GPO_DataSet\GPO_Data.csv", False, "
Any help would be appreciated.
Regards,
James