combobox - removing duplicates

  • Thread starter Thread starter Neil M
  • Start date Start date
N

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
 
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
 
Back
Top