If (Not IsNull(Me.txtStartDate)) And (Not IsNull(Me.txtEndDate)) Then
strsql = strsql & " AND 操作日记.操作时间 BETWEEN #" & Format(Me.txtStartDate, "yyyy-m-d 00:00:00") & "#"
strsql = strsql & " AND #" & Format(Me.txtEndDate, "yyyy-m-d 23:59:59") & "#"
End If
If Me.cboName <> 0 Then
strsql = strsql & " AND 操作日记.操作员 = " & Me.cboName
End If
strsql = strsql & " ORDER BY 操作日记.操作时间"
Debug.Print strsql
Me.操作日记窗体子窗体.Form.RecordSource = strsql
Exit Sub
Err:
MsgBox Err.Number & Err.Description
End Sub 作者: roych 时间: 2011-4-5 23:01
If Me.cboName <> 0 Then
strsql = strsql & " AND 操作日记.操作员 = " & Me.cboName
End If
可能需要加上引号(如果操作员字段是文本的话): If Me.cboName <> 0 Then
strsql = strsql & " AND 操作日记.操作员 = ’" & Me.cboName&“‘”
End If
没看到附件暂时只发现这一点,你不妨把这一句改成注释(即在前面加英文输入法的单引号),执行后按下Ctrl+G,把立即窗口的文本贴上来看看? Me.操作日记窗体子窗体.Form.RecordSource = strsql