I have a form with a combobox. The query for the combobox shows a few values more than one time so I want it to be a DISTINCT query. But I also want the user to be able to type anything they want to type in the field. It appears that if the combobox query is DISTINCT they can't type free text in the field.
Correct? Or is there a work-around for this?