>How do you add a variable to a string that will be used in a command in VB?
>
>For instance if I had a text box where I put a value for the variable myTableName. I then want to add that result to a string. Something like.
>
>myString= "Create Table"(add myfile here) "(name text,name2 text);"
>
>I've tried &myTableName& and &myTableName and they do not work.
>
>Any help will be appreciated.
You need spaces surrounding the ampersand.

myString= "Create Table " & myTableName & " (name text,name2 text);"