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]) ENDIFTo delete record no 6, I use above commnnads
mydelete="delete from logins where logindid=thisform.text1.value"
How to correct above line.