unique value in combo box

[vickiwells]

I need a data entry combo box that pulls it's selections from the existing data (Appraiser) in the table and also allows the entry of a new name if necessary. I can't get it to work. I added DISTINCT to the select statement, but it makes the distinction on the Key field (Parcel #) instead of my Appraiser field.

I tried going to the query and selecting "Unique value" property,and deleting the Parcel # field and then the query looks right, but the combo box shows up blank.

What am I dong wrong?

 

[BarkerD]

If you want the Appraiser field to be unique, go to your table definitions, and set the Index property to Yes(No Duplicates)

Duane Barker

 

[vickiwells]

I don't want the field to be unique, I just want the combo box to show only one instance of each existing value in the selection list. Several Parcels will have the same Appraiser.

 

[Chris RR]

In the query, try setting the Total: for the name field to Group By. If there are records in your Appraiser table that have no name, you may want to add a Criteria: of Is Not Null.