Julie,
What is the index key expression you are using to seek against? It may be that you have to PADR(), the .Values to the length of the fields. You could be trying to compare the following:
"ID ID2 " against "IDID2"
HTH.
>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
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao