I have 3 access files and each one will run a process and refresh an excel spreadsheet. Currently I run each process within the access files seperately and I would like to create a 4th access database that has a single form with a checkbox for each report that needs to be updated. I don't want each of the access files to open, just run the sub routine (cmdRun_Click) for each report that I have selected.

(from the new access form)
Private Sub cmdRun_Click()

DoCmd.SetWarnings False

If Me.chk_dfg_app_rpt.Value = -1 Then
'find app report access file and run cmdRun_Click
End If

If Me.chk_dfg_book_rpt.Value = -1 Then
'find book report access file and run cmdRun_Click
End If

If Me.chk_dfg_except_rpt.Value = -1 Then
'find except report access file and run cmdRun_Click
End If

DoCmd.SetWarnings True

End Sub