'公有变量
Public strsql As String
‘窗体模块
Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
Dim a, b As String
a = Me.RecordSource
b = Me.Filter
strsql = "select * from " & a & " where " & b
DoCmd.OpenReport "RepotName", acViewPreview
End sub
’报表模块
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = strsql
DoCmd.Maximize
End Sub作者: sgrshh29 时间: 2006-1-24 19:10
再简化:(窗体和报表的数据源为同一个数据表)
‘窗体模块
Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
strFilter = Me.Filter
DoCmd.OpenReport "RepotName", acViewPreview, , strFilter
End Sub