ControlSource error message

Following query works. But when I paste as a control source of a text box
on 
a form, it gives me error message: "check the subquery's syntax and
enclose 
the subquery in parentheses". Where did I do wrong?

SELECT Count(tblMaster.Active) AS CountOfActive
FROM tblMaster INNER JOIN qryEnrolled ON tblMaster.SID = qryEnrolled.SID
GROUP BY tblMaster.Active
HAVING (((tblMaster.Active)=Yes));