>>>>I do not get the error on the search but whenever I try to navigate off the entry.
>>>
>>>Use table buffering. What exactly happens when you navigate off the entry?
>>
>>I have
>>

>>buffering set o 2 - optimistic buffering
>>buffermodeovreride set ti 5 - optimistic table buffering
>>

>>which is why I am confused, When I use the navigation buttons O get the error message that the index is violated.
>>
>>In the find U either show the deleted message or if I find the entry I go into edit mode where I can change the values or revert it. in either case I then show the navigation buttons which if I click on them show the error message. If I navigate before using the find button I do not get the error message.
>
>I think you're trying to save the data, that's why you're getting this error. As Al said, make sure you don't have deleted record in the table.

I do not see where I an trying to save the record unless buffering odes it automatically, i so how do I t off.

There is a deleted record in the table, The code in the navigation buttons is

ThisForm.LockScreen				= .T.
DODEFAULT()
ThisForm.RefreshData()
ThisForm.txtFindRelPoNo.Enabled = .T.
ThisForm.LockScreen				= .F.

The code for Refreshdata() is

ThisForm.Lockscreen = .T.
Thisform.Refresh()
ThisForm.txtFindRelPoNo.Value			= ThisForm.txtPoNo.Value
ThisForm.lblDeleted.Caption				= IIF(!DELETED(),' ','Deleted')
ThisForm.Recmodbtns1.cmdDelete.Caption	= IIF(!DELETED(),'\<Delete','\<Recall')
ThisForm.Recmodbtns1.cmdEdit.Enabled	= !DELETED()
ThisForm.txtFindRelPoNo.Enabled			= .T.
ThisForm.Recmovebtn1.Refresh()
ThisForm.Lockscreen = .T.

The refresh code is the default code )as far as I can tell).