Don't know if this is possible but I'll ask anyway.
This code counts the number of records that have the HSKP criteria in the Dept field.
=(DCount("[ID]","[Query1]","[Dept]='HSKP'"))
I'd like to get the criteria for the Dept field from another control on a form instead of coding it in the control. Is this possible?