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