Combo Boxes

[Guest]

I am using a combo box to 'Find a record on my form based on the value I
selected in my combo box' to filter off information to display in a
form/report. One of the Row Sources doesn't have a unique value but I need
the combo box to display unique values only for selection. The data is
company, catchment, wet well id (primary key). One company has many wells. Am
I going to have to normalise my data down again or can a combo box display
unique values only?
Many Thanks

 

[James]

Hi

In the SQL of record source of the combo box change the first line to
read "SELECT DISTINCT..."

If the combo box points directly to a table you may want to change
this to a query so that you can insert the above.

James