fiogf49gjkf0d Hi,
I have been trying something I presumed pretty straight forward, I am trying to pass the ModalResult for an OK or a Cancel button (i.e. 1 or 2) through to another form and inserting them into a variable so I can proceed with an update if the varible = 1.
My form is pretty simple and I have declared my Global Variable as below (a.). I have called the Global variable into a variable on my second form as below (b.) to use for my updates.
I am getting the error 'Type mismatch; 'strResult'', as you can see I have used a msgbox to see if the ModalResult is being passed through and it is not.
I have also tried using an Application.Globalinfo.Add? to set the variable. I cannot find much advice on Global Variables online and would really appreciate it if anybody could advise/point me in the right direction.
Leigh
a.
Dim globstrBankDetailsUpdateScreenClose
Sub AXFormClose(Sender)
'Application.BasicFunctions.GlobalInfoClear Application.BasicFunctions.GlobalInfoSet"globstrBankDetailsUpdateScreenClose", frmBankDetailUpdate.ModalResult
End Sub
b.
Sub cmdUpdateBankDetails(Sender)
Dim strSQL Dim objSLXDB Dim strConfirm Set objSLXDB = New SLX_DB
Application.BasicFunctions.DoInvoke "Form","Personal:BankDetailUpdate"
strConfirm = Application.BasicFunctions.GlobalInfoFor("globstrBankDetailsUpdateScreenClose")
msgbox strConfirm
If strConfirm = 1 then
|