第一次用VBA,就遇到一个怪问题
请看下面的代码,在窗体1上,
Option Explicit
Private colCustomerID As New Collection
Public pCustomerID As String
Public pYear As Long
Public lRet As Long
Private Sub CommandButton1_Click()
lRet = vbOK
pYear = Val(cmbYear.Text)
pCustomerID = colCustomerID.Item(cmbCustomers.ListIndex + 1)
Unload Me
End Sub
Private Sub CommandButton2_Click()
lRet = vbCancel
Unload Me
End Sub
我的另外一个宏里调用
Public Sub GetCustomerSaleDetail()
Dim sSQL As String
Dim rs As ADODB.Recordset
Dim i As Long
Dim j As Long
Dim mFrm As New QueryCustomerYearSales
mFrm.Show vbModal
If mFrm.lRet = vbCancel Then
Exit Sub
End If
'在这里mFrm.pCustomerID得到的结果是空的。
..............
end sub
mFrm.pYear和mFrm.lRet都有内容,可是mFrm.pCustomerID缺是空的。
感觉奇怪,在unload me前设置断点,pCustomerID的确赋值了内容。