>>Nick,
>>
>>This textbox is tied to a table field. In order to type in a job no. wouldn't it affect the current record?
>
>Do you use buffering? If so, you could just use TABLEREVERT() after your validation to get rid of APPENDed record. But if you check the job_no on the same table - there is a possibility that record pointer moves and with record buffering it will update the table and the empty record will get there. That's why I prefer the scenario where you don't add it in the first place.
Sorry, I din't re-read the original message, Then it is a little confusing. You say it is a table, but you also mentioned SPT, so it probably should be the remote view, or cursor created with SPT, isn't it?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison