R
ruth
I've got a switchboard item that uses the run code option to call a function.
My problem is that my function has a parameter and I can't figure out how to
call it. I keep getting: "There was an error executing the command".
My function call is: OpenRept "rptDemographics".
The function itself is in a Module:
Public Function OpenRept(ByVal rpt As String)
DoCmd.OpenForm "frmSelectYrMo", acNormal, , , , , rpt
End Function
My problem is that my function has a parameter and I can't figure out how to
call it. I keep getting: "There was an error executing the command".
My function call is: OpenRept "rptDemographics".
The function itself is in a Module:
Public Function OpenRept(ByVal rpt As String)
DoCmd.OpenForm "frmSelectYrMo", acNormal, , , , , rpt
End Function