If you would follow the instructions I provided the combobox will work. I will repeat (modified to include initials field):
Combobox properties:
RowSource: SELECT QEIID, QEINames, QEInitials FROM tblQEINames ORDER BY QEInames;
BoundColumn: 1
ColumnCount: 3
ColumnWidths: 0";1.5";0.25"
ControlSource: [QEIID] (the field from tblInspectionReports)
Users will see names but QEIID value will be saved.
Advise not to build lookup fields in tables. The filename expression can be in textbox instead of query and reference column of combobox.
=Format([Date of Inspection],"yyyy-mm-dd") & "-" & txtName.Column(2)
Just bind form to table.
InspectionName field which is saving initials should not even be in tblInspectionReports.