Eric,
Did you cut and paste the exact lines from your program into this message, or did you type them in? Could you please check the original lines again, to be sure they are the same?
Also, please put this line before the CREATE TABLE, and see what the value is:
WAIT WINDOW ALLTRIM(Thisform.txtFileName.Value)
Then, try the commands at the Command Window, substituting that value into the first line, to see if they work properly there.
>cFileName = CURDIR()+"DATA\"+ALLTRIM(Thisform.txtFileName.Value)
>CREATE TABLE &cFileName (Field1 N(2), Field2 C(8))
>
>- OR -
>
>cFileName = CURDIR()+"DATA\"+ALLTRIM(Thisform.txtFileName.Value)
>CREATE TABLE (cFileName) (Field1 N(2), Field2 C(8))
>
>returns an error message "Field name is a duplicate or invalid."
>
>What could possibly be wrong?