Thanks Trey,

I was using macro substitution and that solved the problem for me.

Have a nice day,

Michael

>>Hello,
>>
>>lcTrans = getfile("Text:TXT", "Trans", "Trans", 0, "Find the Transaction File")
>>thisform.txtTrans.value = lcTrans
>>
>>I use this code in a form to find the location of a text file which I am appending to a table.
>>
>>My problem is that if the end user places the file in a folder which has a space in the path name, the program blows up with the error message "Command contains unrecognized phrase/keyword". Rather than trapping for the space in the paths (I have several files to locate), is there a way to get around the problem with the space in the path.
>>
>>Any assistance would be greatly appreciated.
>>
>>Michael
>
>Sounds like you are using macro expansion in the append from.
>Instead, use a named expression. - i.e.
>lcTrans = thisform.txtTrans.Value
>Select mytable
>
>** instead of
>Append From &lcTrans Type SDF
>
>** use
>Append From (lcTrans) Type SDF