I have a form with combo boxes bound to a table. As data in input, I will
have duplicates. Can I hide the duplicates without altering the data in the
table?
(Ex: mulitple records will have "sugar pine" as the "species" but we don't
want to scroll down all the sugar pine entries to get to "sycamore").
AJOLSON - 31 Jul 2008 17:02 GMT
If you create a Query then group on the field all duplicates will be
eliminated. Then have your combo box source link with that query instead of
the table.
> I have a form with combo boxes bound to a table. As data in input, I will
> have duplicates. Can I hide the duplicates without altering the data in the
> table?
> (Ex: mulitple records will have "sugar pine" as the "species" but we don't
> want to scroll down all the sugar pine entries to get to "sycamore").