Combo Box Question

[Ron A.]

I have a form with combo boxes that link to a query that creates a report
based on the selections in the combo boxes. The issue I have is that I do not
want the list supplied by the combo box to show duplicates. If I have a
vehicle I buy parts for, I put the registration number of that vehicle in the
purchase table and over a period of time, there may be several entries with
the same registration number. My combo box show all the registration
numbers...so if it is in there 10 times then I see it ten times in the drop
down list for the combo box. I would like to only see it once.

 

[Mr. B]

Ron A,

Change the "Unique Values" property of your query that is providing the list
to your combo box to "Yes".

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[John W. Vinson]

I have a form with combo boxes that link to a query that creates a report
based on the selections in the combo boxes. The issue I have is that I do not
want the list supplied by the combo box to show duplicates. If I have a
vehicle I buy parts for, I put the registration number of that vehicle in the
purchase table and over a period of time, there may be several entries with
the same registration number. My combo box show all the registration
numbers...so if it is in there 10 times then I see it ten times in the drop
down list for the combo box. I would like to only see it once.

What is the Combo Box's RowSource? If it's your table, then it needs to be
changed to a Query that either has the Unique Values property set (as Mr. B
suggests), or to a Totals query; or perhaps to a query selecting from the
Registrations table which you hopefully also have, containing one record per
vehicle.