Running a sub from another sub

hddavie · July 7th, 2011, 04:09 PM

I have searched for this but maybe I am not asking in the proper way, but here is my problem;
I have an Access 2007 accdb that when it opens a form opens, when this form opens I have an event for the Form_Load.
In the Form_Load I want to run a sub routine from a module called transferToMalmoSoback2 the subroutine I want to run is cmdExportToExcel
I am pretty sure I am forgetting the command but everything I try is either just opening the code or giving me an error.

HiTechCoach · July 9th, 2011, 02:52 PM

Try:

Code:

call cmdExportToExcel

jrmontgom · July 30th, 2011, 12:29 PM

Is your function Public or Private in the Module? If it is Public you should be able to just call it: FunctionName(param1,param2)