You cannot just do this
Code:
WHERE CompanyRoleID = CboCompanyRoleID
The query has no idea what CboCompanyRoleID is, nor is it a valid syntax in code.
If it's code on a form, then you have to concatenate with Me
Code:
WHERE CompanyRoleID = " & Me.CboCompanyRoleID & " ORDER BY..."
if it's in a query then
Code:
WHERE CompanyRoleID = Forms!YourFormName.CboCompanyRoleID ORDER BY...
and all that assumes the ID is a number.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.