Hi All
I have some code that works fine in Access 2000 but not in 2007, it's from lebans HTML editor (if you're familiar), it goes like this:
In Access 2003 the code stops running on the open form line and continues when the opened form is closed, this is as it was designed. When I convert this to Access 2007 the form is opened but the code continues to run and then therefore doesn't get run when the form is closed?
Please can anyone advise why Access 2007 is behaving like this and is there a way around?
Thanks
I have some code that works fine in Access 2000 but not in 2007, it's from lebans HTML editor (if you're familiar), it goes like this:
Code:
Private Sub cmdEditHMTL_Click()
On Error GoTo Err_cmdEditHMTL_Click
If IsNull(Me.testmemo) Then
Me.testmemo = ""
End If
DoCmd.OpenForm "frmSHTMLeditor", acNormal, , , acFormEdit, acDialog, Me.testmemo
' For now I'm just using a Public Variable to hold the
' edited contents of the testmemo control.
' I'll encapsulate everything in the next release.
'docmd.OpenForm f,acNormal,,,acFormEdit,acDialog ,acWindowNormal
If Len(strHTML & vbNullString) > 0 Then
Me.testmemo.value = strHTML
End If
Exit_cmdEditHMTL_Click:
Exit Sub
Err_cmdEditHMTL_Click:
MsgBox Err.Description
Resume Exit_cmdEditHMTL_Click
End Sub
In Access 2003 the code stops running on the open form line and continues when the opened form is closed, this is as it was designed. When I convert this to Access 2007 the form is opened but the code continues to run and then therefore doesn't get run when the form is closed?
Please can anyone advise why Access 2007 is behaving like this and is there a way around?
Thanks