I run into the same issue recently and did a workaround outside of the Geo-HMS.
The Zonal Statistics as a Table in Spatial Analyst was used to create a CN Grid table for each HydroID in the subbasin layer. This table was joined to the subbasin layer first, and then the field calculation was used to populate the CN field.