Obtaining a Report using a Form to extract details from a table

I am trying to create a form based on a query. My database table is linked to another table, everytime i try to create a combo box based on the query to look at the records allocated to me, if the log is closed, the priortiy level etc.

i am not getting a drop down list of the people available in the tables list, instead i am getting all the records allocated to everyone in the combo box.

Please could someone advise urgently, as i have nearly finished building the databse and its only the reports that are left to complete.

If you need to take a look at my database please let me know and i can send this on to you. However you may need to go into the database and link the tables again.

Many thanks in advance for your assistance in this matter.

Thank you,

Manjeet