Sub Routine

[kitty77]

I have a report that has several buttons on it. Send to a folder as a pdf, email, etc...
I created a sub rountine for those buttons. How can I use that same sub routine on other reports?

Thanks.

 

[MajP]

Put the sub routine in a Standard module. The routine will likely need arguments. Maybe something like

Public Sub SendToFolder (rpt as Access.report, SaveType as String)
  do code
end sub

now call it from your report

SendToFolder me, "PDF"

 

[The_Doc_Man]

With a word of warning to be added to MajP's suggestion:

IF any of these routines that you intend to re-use includes the qualifier Me. or Me! for any control, it will not work correctly from the standard module. The Me reference is only valid within the class module that contains the given object for which that is a qualifier.

Note that he included Me in the calling sequence but in the common routine he included a formal parameter called rpt. In the standard module code, you would use rpt as your prefix.