>>> 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
How about just:
APPEND FROM DBF("alias")
Craig
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer