I made the changes suggested in answer 1. The form sorts correctly but now the recordset is not updateable. When I take the join out of the sql, the from is updateable (but does not sort correctly).

Did some searching around the internet. Many of the answers related to primary key. My tables all have an autonumber field and I usually make that the primary key. I went into Task-TrainingStatus and changed the primary key from the autonumber to the Id that I used for the combobox and it works!