button on form won't work - MS Access

Private Sub button_mlappeal_Click()
On Error GoTo Err_button_mlappeal_Click
 
    Dim stDocName As String
    Dim SQL As String
    Dim rptgroups As Form_frmReportsGroupsMailingList
    Dim formname As String
    
    Set rptgroups = Form_frmReportsGroupsMailingList
    
 
    formname = IsLoaded("frmReportsGroupsMailingList")
 
    If formname = True Then
      rptgroups.Visible = False
    End If
 
 ' put the table name to be deleted in this bracket
 SQL = "DROP TABLE [tblDonator-Appeal-MailingLabels]"
 DoCmd.RunSQL SQL
 ' put the query to be run inside the Quotes
 stDocName = "qryDonator-Appeal-MailingLabels"
 DoCmd.OpenQuery stDocName, acNormal, acEdit
 ' put the report that has been called between the quotes
 
 
    stDocName = "rptDonator-Appeal-MailingLabels"
    DoCmd.OpenReport stDocName, acPreview
 
Exit_button_mlHorizon_Click:
    Exit Sub
 
Err_button_mlHorizon_Click:
    MsgBox Err.Description
    Resume Exit_button_mlHorizon_Click
    
End Sub
 
 
 
 
 
 
Private Sub button_mlHorizon_Click()
On Error GoTo Err_button_mlHorizon_Click
 
    Dim stDocName As String
    Dim SQL As String
    Dim rptgroups As Form_frmReportsGroupsMailingList
    Dim formname As String
    
    Set rptgroups = Form_frmReportsGroupsMailingList
    
 
    formname = IsLoaded("frmReportsGroupsMailingList")
 
    If formname = True Then
      rptgroups.Visible = False
    End If
 
 ' put the table name to be deleted in this bracket
 SQL = "DROP TABLE [tblDonator-Horizon-MailingLabels]"
 DoCmd.RunSQL SQL
 ' put the query to be run inside the Quotes
 stDocName = "qryDonator-Horizon-MailingLabels"
 DoCmd.OpenQuery stDocName, acNormal, acEdit
 ' put the report that has been called between the quotes
 
 
    stDocName = "rptDonator-Horizon-MailingLabels"
    DoCmd.OpenReport stDocName, acPreview
 
Exit_button_mlHorizon_Click:
    Exit Sub
 
Err_button_mlHorizon_Click:
    MsgBox Err.Description
    Resume Exit_button_mlHorizon_Click
    
End Sub

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80: