>Barbara....
>
>Do you need to put the full field name in the oldval? veventbar.qtystart?
>
>
>
>>Well, There's ALWAYS 3 ways to do anything with VFP :-)
>>
>>>Barbara...
>>>
>>>Ya know, sometimes I just hate programming!!!! Here you pointed out another, wonderful, command (oldval) that
>>>I didn't even know existed and I fought a problem programatically awhile ago for a similar need. Geez.
>>>
>>>I'll give the OldVal routine a whirl and see if that works. Seems easier.
As Barbara said I suggest to use both like :
oldval("myfield","mytable")
Also it's wise to use it like :
nvl(oldval("myfield","mytable"),"") = nvl(this.value,"")
to prevent trying to compare .NULL. to notNull values. It occurs even if your table doesn't accept nulls when it's a new record (oldval() is null).
Cetin