Text1.Text = ""
Text1.SetFocus
Data1.RecordSource = "select * from load where name='" & kk & " '"
Text1.SetFocus
kk = Trim(Text1.Text)
Dim kk As String
Data1.Recordset.AddNew
Data1.Recordset.MoveFirst
Text1.Text = ""
Text1.SetFocus
Data1.RecordSource = "select * from load where name='" & kk & " '"
Text1.SetFocus
kk = Trim(Text1.Text)
Dim kk As String
Data1.Recordset.AddNew
Data1.Recordset.MoveFirst
Text1.Text = "" //清空数据
Text1.SetFocus //设置焦点
Data1.RecordSource = "select * from load where name='" & kk & " '" //查询语句
Text1.SetFocus //设置焦点
kk = Trim(Text1.Text) //将值赋给kk
Dim kk As String //定义字符串kk
Data1.Recordset.AddNew //添加新记录
Data1.Recordset.MoveFirst //指针移到第一位