Set MyCmdStr.ActiveConnection = Conn1
MyCmdStr.CommandText = "Select * from WeightTab where 班号 = " & "'" & Trim(Combo1.Text) & "'" & " and 机台号 = " & "'" & Trim(Combo2.Text) & "'" & " and 保存日期 = " & "'" & Trim(DTPicker1.Value) & "'"
' Debug.Print MyCmdStr.CommandText
Set MyRecordSet = New ADODB.Recordset
MyRecordSet.CursorLocation = adUseClient
MyRecordSet.CursorType = adOpenKeyset
MyRecordSet.Open MyCmdStr, , adOpenStatic, adLockBatchOptimistic
m_Report.Database.SetDataSource MyRecordSet
m_Report.SQLQueryString = "Select * from WeightTab where 班号 = " & "'" & Trim(Combo1.Text) & "'" & " and 机台号 = " & "'" & Trim(Combo2.Text) & "'" & "保存日期 = " & "'" & Trim(DTPicker1.Value) & "'"
Screen.MousePointer = vbHourglass
FrmWeigth.CRViewer1.ReportSource = m_Report
FrmWeigth.CRViewer1.ViewReport
Screen.MousePointer = vbDefault
FrmWeigth.Show
MyRecordSet.Close
MyCmdStr.CommandText = "Select * from WeightTab where 班号 = " & "'" & Trim(Combo1.Text) & "'" & " and 机台号 = " & "'" & Trim(Combo2.Text) & "'" & " and 保存日期 = " & "'" & Trim(DTPicker1.Value) & "'"
' Debug.Print MyCmdStr.CommandText
Set MyRecordSet = New ADODB.Recordset
MyRecordSet.CursorLocation = adUseClient
MyRecordSet.CursorType = adOpenKeyset
MyRecordSet.Open MyCmdStr, , adOpenStatic, adLockBatchOptimistic
m_Report.Database.SetDataSource MyRecordSet
m_Report.SQLQueryString = "Select * from WeightTab where 班号 = " & "'" & Trim(Combo1.Text) & "'" & " and 机台号 = " & "'" & Trim(Combo2.Text) & "'" & "保存日期 = " & "'" & Trim(DTPicker1.Value) & "'"
Screen.MousePointer = vbHourglass
FrmWeigth.CRViewer1.ReportSource = m_Report
FrmWeigth.CRViewer1.ViewReport
Screen.MousePointer = vbDefault
FrmWeigth.Show
MyRecordSet.Close
MyCmdStr.CommandText = "Select * from MyTab"
Set MyRecordSet = New ADODB.Recordset
MyRecordSet.CursorLocation = adUseClient
MyRecordSet.CursorType = adOpenKeyset
MyRecordSet.Open MyCmdStr, , adOpenStatic, adLockBatchOptimistic
m_Report.Database.SetDataSource MyRecordSet
m_Report.SQLQueryString = "Select * from MyTab"
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = m_Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault