Here is the SQL for the rowsource on the combo box:
SELECT DISTINCT [TRAINING COMPLETION DATES].REC, [LAST NAME]+", "+[FIRST NAME] AS CAFULLNAME, [TRAINING COMPLETION DATES].[TNG NO], PEOPLE.POS, PEOPLE.AC, [RECURRENT TRAINING SESSIONS].CREW, [RECURRENT TRAINING SESSIONS].RECNO, PEOPLE.[PC...