>>>I have a child table with table buffering 5, and put (!empty(field1) and !empty(field2)) in record validation rule. In the cancel button, I want to check IF GetNextModified(0) <> 0 to see if there is any changes or new record is added. But I found that error is returned from GetNextModified(0) when record validation is failed in the appending record.
>>>
>>>Please help...
>>>Many Thanks!
>>>
>>>Rosanna
>>Rosanna,
>>
>>I reported this behaviro to MS a while ago and was told it is by design as GetnextModified() moves the record pointer.
>
>So, there is no other command to check if incomplete record is added in a buffering 5 table??
Rosanna,
Based on your message you can simply issue a TableRevert() on that buffer in the cancel button.