Could anyone tell me, instead of having undefinedundefined to specify a file name in the vb code could i put an inputbox code in there so when the transfertext code is run it will ask me for a file name???
You could simply nest an InputBox statement within the TransferText method as follows. Please keep in mind that the following syntax was created solely as a sample to your question. (no word wrap) You MUST have specifications defined in order for this to work.
Private Sub Command0_Click()
DoCmd.TransferText acImportDelim, "TestSpecs", "tblTest", "C:\" & InputBox("Please enter a file name")