Access如何将动态填充的未绑定Orders_Print表单嵌入Orders表单作为子窗体显示
问题根因
Orders_Print是未绑定表单,所有控件值由VBA手动填充,Access原生的父子窗体关联功能仅支持绑定了数据源的表单,所以设置关联会报错。- 现有
saveAsPDF过程默认操作的是独立打开的顶层表单实例,嵌入到Orders表单里的子窗体实例不属于Forms顶层集合,之前的填充代码根本没有作用到子窗体上,所以只会显示设计时的静态内容。 - 未绑定表单的手动填充内容不会响应
Requery操作,Requery只会刷新绑定了数据源的控件,所以你尝试的各类Requery操作均无效。
解决步骤
- 修改
saveAsPDF过程,支持直接传入表单实例,不再依赖顶层Forms集合和DoCmd.OpenForm逻辑区分独立表单和子窗体场景 - 在Orders表单的订单选择事件(比如订单日期列表框的更新后事件)中,直接获取子窗体实例,传入修改后的过程完成填充
- 移除无用的父子关联设置和Requery代码
修改后代码示例
调整后的填充过程
' 调整参数,支持直接传入Form实例,PO为要查询的订单号 Public Sub fillOrdersPrintForm(frm As Form, PO As String, Optional exportAsPDF As Boolean = False) ' 不再需要DoCmd.OpenForm,传入的frm已经是加载好的实例(独立窗体/子窗体都适用) Dim ii As Integer With frm.lstOrderItems For ii = .ListCount - 1 To 0 Step -1 .RemoveItem (.ListCount - 1) Next ii End With frm.txtVender = "" frm.txtPO = "" Dim fileName As String Dim vender As String Dim orderDateIs As String Dim rs As DAO.Recordset Dim sSQL As String Dim i As Integer sSQL = "SELECT Orders.*, Items.ID, Items.VenderSKU as VenderSKU,Items.VenderItemName as ItemName, Venders.ID, Venders.VenderName as VenderName" sSQL = sSQL & " FROM (Orders INNER JOIN Items ON Orders.ItemID = Items.ID) " sSQL = sSQL & " left JOIN Venders ON Orders.VenderID = Venders.ID" sSQL = sSQL & " WHERE Orders.PO = '" & PO & "'" Set rs = getRecord(sSQL) Call frm.setLstItems ' 改成调用当前传入表单的setLstItems方法,不要硬写Forms.Orders_Print Do While Not rs.EOF i = i + 1 vender = rs!VenderName orderDateIs = Format(rs!OrderDate, "yyyy.mm.dd-hh.mm.ssAM/PM") orderDateIs = Replace(orderDateIs, "AM", "") orderDateIs = Replace(orderDateIs, "PM", "") frm.txtVender = vender frm.txtOrderDate = Format(rs!OrderDate, "Short Date") frm.txtOrderTotalCost = rs!TotalOrderCost ' 原条目格式化逻辑保持不变 Dim itemLen As Integer Dim itemNameShort As String Dim itemNameShortBuild As String Dim itemNameShortBuildArray() Dim x, y, z As Integer Dim splitStringAt As Integer Dim spl As Variant x = 0 y = 0 z = 0 splitStringAt = 73 itemNameShort = rs!ItemName spl = Split(itemNameShort, " ") If Len(itemNameShort) > splitStringAt Then For x = 0 To UBound(spl) itemNameShortBuild = itemNameShortBuild & spl(x) & " " If Len(itemNameShortBuild) < splitStringAt Then itemNameShort = itemNameShortBuild Else ReDim Preserve itemNameShortBuildArray(y) itemNameShortBuildArray(y) = itemNameShort itemNameShortBuild = "" y = y + 1 x = x - 1 End If Next x ReDim Preserve itemNameShortBuildArray(y) itemNameShortBuildArray(y) = itemNameShort itemNameShortBuild = "" itemNameShort = "" Else ReDim Preserve itemNameShortBuildArray(0) itemNameShortBuildArray(y) = itemNameShort End If itemNameShortBuild = "" itemNameShort = "" For z = 0 To UBound(itemNameShortBuildArray) If z = 0 Then frm.lstOrderItems.AddItem rs!VenderSKU & ";'" & itemNameShortBuildArray(z) & "';" & rs!OrderQTY & ";$" & rs!TotalItemCost Else frm.lstOrderItems.AddItem ";'" & itemNameShortBuildArray(z) & "';" End If Next z frm.lstOrderItems.Selected(i) = False rs.MoveNext frm.txtPO = PO Loop rs.Close Set rs = Nothing ' 导出PDF逻辑仅在需要的时候执行 If exportAsPDF = True Then fileName = projectPath & "POs\" & vender & "\" Call makeDir(fileName) fileName = fileName & "PO." & PO & "_" & vender & "_" & orderDateIs & "_" & currentUserName & ".pdf" DoCmd.OutputTo acOutputForm, frm.Name, acFormatPDF, fileName DoCmd.Close acForm, frm.Name, acSaveNo Call runit(fileName) End If End Sub
Orders表单触发逻辑
放到Orders表单里订单/日期列表的更新后事件中即可:
Private Sub lstOrderDate_AfterUpdate() ' 假设你选中的PO号存在控件txtSelectedPO里,子窗体控件名为subOrderDetails,可根据实际情况修改 Dim selectedPO As String selectedPO = Me.txtSelectedPO ' 直接传入子窗体实例完成填充 Call fillOrdersPrintForm(Me.subOrderDetails.Form, selectedPO, False) End Sub
原有导出PDF功能兼容调用
' 独立导出PDF场景的调用方式保持兼容 Call fillOrdersPrintForm(Forms("Orders_Print"), "目标PO号", True)
内容的提问来源于stack exchange,提问作者SidewaysUpJoe
相关产品推荐
相关产品推荐

