Me again with yet another question

Used the combobox wizard to create a combobox that references a list of suburbs from a table. Only problem is that there are of course records that contain the same suburb and so when you use the drop down list you see multiples.

What would be the best method to avoid the dup data?

Thanks once more.

Highlight the combo in design view, go to rowsource and use a query as the rowsource, change the view to sql view and after select, write 'distinct'

too easy. just a wealth of knowledge