Julie,

In order for SEEK to work, expression in SEEK mast match expresion in the current index. What is index key for the current tag in the table?

>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