I tried to set a form Order By property = parents.parentID meaning parent Table, then parentID field. I have since deleted that code. But when I attempt to go back into form view I am prompted to enter parents.parentID.
Note: Originally I should have typed tblParents instead of parents. Not sure if this has something to do with the problem.
Anyway, I have deleted the code that I previously wrote, saved changes, and Access still thinks that this line of code is present when it is not. Any ideas what is going on?