ROTFL, given David appearence (he looks rather bearish to me!), I would reccomend that you follow his advice without bearing from the path that he has set you! ~Frank~ly given the bear facts that you have shared with us about your project, table buffering is surely the best solution, fur using memvar's is OLD OLD tech, and prone to many a problem. Going ~bach~ to the old days isn't the way to go.
>David,
>Thanks for the advice. It did work but you might be right about bindly directly to the table. This is turning out to be a bear. :)
>
>Thanks again!
>Amanda
>
>>Amanda,
>>
>>You can just set the memvar to "".
>>
>>I'd strongly urge you to leave the memvar style of coding behind you and bind directly to the table fields. The buffering in VFP easily allows you to commit the user changes with TableUpdate() or undo them with TableRevert().
>>
>>>I have a blank form that users enter new provider info into, this form does not have a controlsource. I'm declaring variables and using insert from memvar to insert into my table. My problem is, I have a memo field for users to type notes but the memo field refuses to go into the table. I had to initialize some of the other variables (ie. date, char, etc), so how would I initialize a memo variable?
--Todd Sherman
-Wake Up! Smell the Coffee!