Duplicates in Combo box

[MFFenton]

I am having a huge problem with multiple occurances of data in a combo box. I am creating a database that will log computer problems and solutions. In the problem log form, when you have a computer that has already had the some problem as the current machine, you can use the combo box to select the problem. However, the combo box shows the same problem for each occurance. Example, if 5 computers were having a the same printing problem, the problem would show up 5 times in the combo box. What can I do to prevent the duplicates from showing up?

 

[Jimbob]

Maybe a table of problems is the way forward, if you haven't got one already.

That way in a query you could base the 'Problem' criteria on the combo box on your form. When linking the 'Problems' table to the 'Calls' table in the query make sure you specify the join type as

"Show all records from table problems and only those from table Calls where the joined fields are equal"

and then have a subform on that form which displays the results of the query.....

 

[ColinEssex]

In the properties of the combo box select 'Row source' - there is a little box to the right with 3 dots on it ... click on that to get to the query behind the combo bos and then select the group by. This will eliminate duplicates, but not if they are the same but spelt differently e.g. Software and Software. (with a full stop) or whatever.

Hope this helps
Col