Hello Julie:
What exactly do you mean "not working", do you mean the record is not deleted or the record is still displaying in your form.
If the record is not deleteing, Is the table buffered, if so do a Tableupdate.
If the record is still displaying, set delete on
Either case its a good idea to set delete on. Also make sure the right index tag is selected before the seek.
Good Luck
Mohammed
www.imaginecorp.com/whatwedo.htm >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