No combo box duplicates 1

[ind]

I have a form with several combo-boxes (city, state, county, and country) . There recordset is a query listing the city, state, county, and country. How can I keep the combo-boxes form display duplicate values.

 

[JimConrad]

While in query design, select from the menu bar...<br><br>View/Totals<br> <p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>

 

[DiscoDuane]

for the row source to say Select distinct<br><br>SELECT DISTINCT [tblPC].[Model] FROM tblPC ORDER BY [tblPC].[Model];

 

[Halifax]

In your query that extracts the data for each combobox, open thequery property sheet and make sure that the UniqueValue propery = YES<br>