想删除符合条件的记录，这么写行么？
DelAllRecord.Open "select * from 调动信息 where 员工编号= ' " & CmbCodeID.Text & " ' ", DBCON, adOpenKeyset, adLockPessimistic, adCmdText

while DelAllRecord.EOF

DelAllRecord.Delete
' 这里是不是要什么语句，让记录集的指针向下移?
Endw
DelAllRecord.Close

[解决办法]
用ADO控件最简单:

DatabaseLinkStr= "Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=sa;Initial Catalog=databasename;Data Source=127.0.0.1 "
Adodc1.ConnectionString = DatabaseLinkStr
Adodc1.RecordSource = "delete from 调动信息 where 员工编号= ' " & CmbCodeID.Text & " ' "
Adodc1.Refresh
[解决办法]
上面主的操作太麻了，
一般的添加除操作只需用execute 事件就行了
操作最好用
全局明
public sqlconn as adodb.connection
set sqlconn= new adodb.connection
sqlconn.connectionstring = "Provider=SQLOLEDB;Data Source= " & ipstr & ";User ID=appuser;Password=hferp;Initial Catalog=ERP "
sqlconn.Open
sqlconn.execute "delete from 调动信息 where 员工编号= ' " & CmbCodeID.Text & " ' "

[解决办法]
sqlconn.execute "delete from 调动信息 where 员工编号= ' " & CmbCodeID.Text & " ' "

这个比较高效