Since there were no replies, and I have managed to solve the issue, here is what I have concluded and done. Maybe someone will find it helpful. Also, if somebody has any insight or comment, please do reply.
As I have realised, the problem was not in the query, but in the Combo box. Which I find...