Attached is a workbook I am creating. I have two functions called within the Macro GoBtn: fn_pcp and fn_ip.
The first function works without a problem. The fn_ip gives me an error that the ocn is invalid.
the two functions are essentially the same except for the connection name and the stored procedures being called by the connection.
I have checked that the connection name exists, "CPOEPhysInpatients" It does.
I checked that the stored procedure being called in the command text exists, GetCPOEPhysDatasummary_Inp
atient. It does.
Can you review the vba code and let me know where the error is?