Dim dt As Date = Date.Today.AddDays(10)
Dim dr As DataRow = DataTables("材料跟催提醒").Find("计划回厂 >= #" & Date.Today & "# and 计划回厂 <= #" & dt & "#")
If dr IsNot Nothing Then
Forms("材料跟催提醒").Show
Tables("材料跟催提醒").Filter="审核=False"
Tables("材料跟催提醒").Filter = "计划回厂 >= #" & Date.Today & "# and 计划回厂 <= #" & dt & "#"
End If
以上代码是筛选材料跟催提醒表里面的“审核”=FALSE 的日期大于今天的行,请求代码修改