How do I pass Mulitple Parameters to a Microsoft Access Subroutine?

Hi,

I have a VBA Subroutine in Microsoft Access.  I am trying to pass two variables to the subroutine but keep getting errors.

This is how I have set up the sub:

Sub ExportAll_Weekly_ToExcel(Employee_Type As String, FName As String)

This is how I am trying to pass the values into the sub

ExportAll_Weekly_ToExcel ("qry_Weekly_Report_Account_Mgr_Append","AM")

When doing this I get the error "Compile error: Expected:=".  Not the sub works find with just one parameter "Employee_Type",  I only get problems when I try and add "FName"





Start Free Trial