主页 / user-453116

lalachka's questions

Martin Hope
lalachka
Asked: 2025-03-30 04:40:35 +0800 CST
  • 5

我在表单的子表单1上有下面的代码。这指的是同一表单上不相关的子表单2（fzzzSubConditionalFormatCriteria）。

打开主窗体时，我收到“：窗体：<您输入的表达式对属性窗体/报告的引用无效。>：窗体”错误，但之后当我单击记录时，它工作正常。我该如何解决这个问题？或者，最坏的情况是，不要在打开窗体时运行此代码

基本上，需要一种方法来判断子表单何时加载并可以访问

  vrSQL = "SELECT zzAppObjectFields.AppObjectField, zzAppObjectFields.AppObjectFieldTypeID, zzAppObjectFields.AppObjectIDCmb " & _
                            "FROM zzAppObjectFields WHERE zzAppObjectFields.AppObjectFieldTypeID In (10,12) AND zzAppObjectFields.AppObjectID=" & Me.AppObjectID & " " & _
                            "ORDER BY zzAppObjectFields.AppObjectField;"
    
                Me.Parent.fzzzSubConditionalFormatCriteria.Form!uuulllAppObjectFieldIDCriteria.RowSource = vrSQL
                Me.Parent.fzzzSubConditionalFormatCriteria.Form!uuulllAppObjectFieldIDCriteria.Requery
vba