combobox - removing duplicates

[Neil M]

Is there anyway to remove showing duplicate records ina subform linked to a
query

The query just shows NAMES in AZ order from the table, but I dont want the
combo to show duplicate names?

Thanks.

Neil

 

[Guest]

Make your query a Totals query and use a Group By on the names.

 

[Brendan Reynolds]

Neil, your subject line says 'combobox', but the body of your message says
'subform'.

If a combo box, you need to modify the row source property, if a subform,
you need to modify the record source property. Either way, if the property
is referring directly to the table, change it to a SQL statement using the
DISTINCT keyword like so ...

SELECT DISTINCT YourFieldName FROM YourTableName

Here's a link to the relevant on-line help topic ...
http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP010322051033