Hi Tariq,

you can use bind parameter:

=SQLEXEC(mconec,"delete from logins where logindid=?thisform.text1.value")
* OR
liID=thisform.text1.value
=SQLEXEC(mconec,"delete from logins where logindid=?liID")

>

MartinaJ

>

>mconec = SQLSTRINGCONNECT("Driver={Microsoft Access Driver (*.mdb)};Dbq=f:\wet2004;Uid=admin;Pwd=")
>IF mconec > 0
>   mydelete="delete from logins where logindid=6"
>   IF SQLEXEC(mconec,mydelete) < 0
>      AERROR(laError)
>      MessageBox([Can't delete ] + laError[1,2])
>   ENDIF
>ELSE
>   AERROR(laError)
>   MessageBox([Can not connect] + laError[1,2])
>ENDIF
>

>
>To delete record no 6, I use above commnnads
>But when I use following command then it do not work
>

>mydelete="delete from logins where logindid=thisform.text1.value"
>

>How to correct above line.
>
>Please help