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?

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

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.

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.