Try
SEEK idcode+idcode2
That way rushnore will kick in
Peter
>I am calling the correct index (from the main program) and it is
>idcode+idcode2.
>
>>1. Do you have the order set to the correct TAG?
>
>>2. Can we see the exact TAG definition involved?
>
>
>>good luck
>
>>>I am trying to set a form up so that the user can enter the necessary codes and then click on the delete button to delete a certain record. Needless to say, it is not working! Below is the code that I have in the click method of the delete button.
>>>
>>>SELECT table1
>>>SEEK ALLTRIM(THISFORM.idcode.Value)+ALLTRIM(THISFORM.idcode2.Value)
>>>IF FOUND()
>>> SELECT table1
>>> DELETE
>>> WAIT WINDOW 'Record has been deleted.'
>>>
>>> THISFORM.Refresh
>>>ELSE
>>> WAIT WINDOW Record does not exist'
>>>ENDIF
>>>SELECT table1
Peter Cortiel