Running stored procedure from .adp module
I'm trying to run a Do.Cmd open stored procedure that takes two arguments. The arguments are global variables that were set in Access during an Event procedure. I can't seem to get the syntax of this method. The SQL Server arguments are named the same as VBA Globals. Without the arguments it runs just fine, but with it's a different story. Thank you in advance
DoCmd.OpenStoredProcedure "spEVA_Export @EndDate='" & EndDate & "', @Account1='" & Account1 & "'"