Your spacing in your query is slightly off, see the alteration below:
qry2 = "SELECT * FROM [per_diem_accomodation] WHERE [project number]='" & projcode & "' AND [employee number]='" & empcode & "'" & _
" AND [current month]= (SELECT MAX(current month) FROM [per_diem_accomodation] WHERE
[project number]='" & projcode & "' AND [employee number]='" & empcode & "')"
The second "AND" in your query has a space before it.