access 2007 - combo box + multiple records?

Hi,

I have an access database that displays the users and equipment in my office and which equipment is used by which user. I have a user and equipment table as well as query combining this info.

I have created a form using a combo box where the user can be selected and the equipment they use is displayed. But in some cases the users have more than 1 piece of equipment e.g. a laptop and pc or a pc and printer. I can only seem to get it to display 1 piece of equipment at a time and also found that the users name appeared twice in the combo box if they had more than 1 piece of equipment associated to them.

Anyone know how i can get the form to display more than 1 piece of equipment thus showing their name once??

Thanks in advanced.