multi-part identifier can't be bound error when adding "Order By" clause in Access 2010

I'm building a form with 2 subforms in Access 2010 ADP to SQL Server 2008. I've got the fields and everything showing like I want them to and hooking into the controls okay. However, when I try to sort the Record Source, I get the "multipart identifier can't be bound" error. If I run the SQL in the Query builder in access, it retus records fine. It's just when the form loads that it throws the error. If I remove the Order By out of the SQL, the form loads just fine.

Record Source of subform:

SELECT      tblTaskTracker.EmployeeID, tblTaskTracker.ProjectID, tblTaskTracker.ReleaseID, tblTaskTracker.TaskStatusID, tblTaskTracker.TaskPriorityID, 
                        tblTaskTracker.DueDate, tblTaskTracker.Notes, tblTaskTracker.CompDate, tblTaskTracker.QCByID, tblTaskTracker.QCDate, tblProject.ProjectName, 
                        tblTaskCode.TaskCodeAbbr
FROM          tblTaskTracker INNER JOIN
                        tblProject ON tblTaskTracker.ProjectID = tblProject.ProjectID INNER JOIN
                        tblTaskCode ON tblTaskTracker.TaskCodeID = tblTaskCode.TaskCodeID INNER JOIN
                        tblTaskStatus ON tblTaskTracker.TaskStatusID = tblTaskStatus.TaskStatusID
WHERE      (tblTaskStatus.TaskStatusType = 'A')

If I add

ORDER BY tblTaskTracker.TaskPriorityID

at the end, I can click Run and I get the expected results back. However, when I close out of the query builder and try to load the form, I get the multi-part identifier "tblTaskTracker.TaskPriorityID" could not be bound. I click OK on that message and that subform doesn't load.