You need to enable JavaScript to run this app. Access如何将动态填充的未绑定Orders_Print表单嵌入Orders表单作为子窗体显示
优惠活动
大模型
产品
解决方案
定价
更多

Access如何将动态填充的未绑定Orders_Print表单嵌入Orders表单作为子窗体显示

问题根因

  1. Orders_Print是未绑定表单,所有控件值由VBA手动填充,Access原生的父子窗体关联功能仅支持绑定了数据源的表单,所以设置关联会报错。
  2. 现有saveAsPDF过程默认操作的是独立打开的顶层表单实例,嵌入到Orders表单里的子窗体实例不属于Forms顶层集合,之前的填充代码根本没有作用到子窗体上,所以只会显示设计时的静态内容。
  3. 未绑定表单的手动填充内容不会响应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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.10.12 21:18:01