我在主表單建了一個預覽報表的按鈕,添加事件程序如下圖代碼:
Private Sub 預覽報表_Click()
On Error GoTo Err_預覽報表_Click
Dim ss As Long
需求單編號.SetFocus
Dim stDocName As String
ss = 需求單編號.Text
stDocName = "物流需求單"
DoCmd.OpenReport stDocName, acPreview, "", "[需求單編號] =" & ss & ""
Exit_預覽報表_Click:
Exit Sub
Err_預覽報表_Click:
MsgBox Err.Description
Resume Exit_預覽報表_Click
End Sub
然后在子表單錄入條目的時候,ITEM錄入幾項,點擊預覽報表按鈕就會生成幾頁重復的報表,怎么去除重復的報表


轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/268107.html
標籤:Access
上一篇:千萬級唯一索引查詢慢
下一篇:按欄位拆分access
