First, you should check if record you're going to delete exists. What's the point in asking the user if they wantb to delete non-existent record?

>I am deleting records with these codes
>I have problem some time, if any best instead of this.thanks
>

>xxz = MESSAGEBOX( ;
>      "Are you sure you want to Delete Record?",  ;
>      36)
>IF xxz = 6
>     DELETE 'syllabus' FROM syllabus  ;
>            WHERE syllabus.sno ==  ;
>            thisform.txtsno.value
>ENDIF