cbobox that has duplicate values?

[Guest]

Good Day,

I use a cbobox to search for specific dates within my tblorders, and it is
possible for my multiple orders to have the same date value.

Is is possible to limit my cbobox only to single date values and not their
duplicates?

Thanks,

Brook

 

[David W]

Try this, it might work for you.
Open the recordsource in the combo's property box, once open you will see a
query, right click in the table section(not on a table) and click
properties, look for unique values and change to yes.

 

[Guest]

David,

Thank you very much!!

That worked perfectly... and when I made the changes I was able to save a
"new query" that was used for the cbobox.

Thanks again,

Brook