Private Sub cmdPrint_Click() Dim PurhcaseCon As ADODB.Connection Dim str As String Dim secDetail As Section Dim rs As ADODB.Recordset With mPurchase str = .PrintStr End With Set rs = mPurchase.QueryPrint(str) Set secDetail = rptPurchase.Sections(3) Set rptPurchase.DataSource = rs secDetail.Controls("Text1").DataField = "PurchaseNo" secDetail.Controls("Text2").DataField = "SPID" secDetail.Controls("Text3").DataField = "SPName" secDetail.Controls("Text4").DataField = "BuyQuan" secDetail.Controls("Text5").DataField = "UnitTypeName" secDetail.Controls("Text6").DataField = "BuyPrice" secDetail.Controls("Text7").DataField = "BuyAmount" secDetail.Controls("Text8").DataField = "ProvideDate" secDetail.Controls("Text9").DataField = "ShipName" rptPurchase.ShowEnd Sub看看俺做的!!! 这样挺不错的试试看!!
(我是动态绑定的field哟)
Dim PurhcaseCon As ADODB.Connection
Dim str As String
Dim secDetail As Section
Dim rs As ADODB.Recordset
With mPurchase
str = .PrintStr
End With
Set rs = mPurchase.QueryPrint(str)
Set secDetail = rptPurchase.Sections(3)
Set rptPurchase.DataSource = rs
secDetail.Controls("Text1").DataField = "PurchaseNo"
secDetail.Controls("Text2").DataField = "SPID"
secDetail.Controls("Text3").DataField = "SPName"
secDetail.Controls("Text4").DataField = "BuyQuan"
secDetail.Controls("Text5").DataField = "UnitTypeName"
secDetail.Controls("Text6").DataField = "BuyPrice"
secDetail.Controls("Text7").DataField = "BuyAmount"
secDetail.Controls("Text8").DataField = "ProvideDate"
secDetail.Controls("Text9").DataField = "ShipName"
rptPurchase.ShowEnd Sub看看俺做的!!!
这样挺不错的试试看!!