Dim Filter As String Dim Product As String Dim Discount As Double With e.Form.Controls("TextBox1") Product = .value If Product > "" Then Filter = "[姓名] Like " & "'*" & product & "*'" & " Or [身份证号码] Like " & "'*" & product & "*'" & " Or [户主] Like " & "'*" & product & "*'" End If For Each dr1 as DataRow In DataTables("适龄青年数据库").Select(Filter) Dim dr2 As DataRow = DataTables("报名数据").AddNew For Each c As DataCol In DataTables("适龄青年数据库").DataCols dr2(c.Name) = dr1(c.Name) Next Next End With