>> After the first run of this program, I found out that the append table command does not like to have a memory variable substituted for an actual file name. I started to figure out an alternative way to append my foxpro table. But I do not know enough about how VFP deals with opening/appending files from a form. At this point I'm not sure if VFP is designed to do this.
>
>try macro substitution
>
>myvar=alltrim(thisform.control.value)
>APPEND FROM &myvar
>
>HTH
>
>Arnon
An alternate syntax is
APPEND FROM (myvar)
One note: If you're appending from a cursor you will need to find out the 'Real' name and location of the cursor, not the alias. Use the "dbf()" function for this.
Barbara Paltiel