Add the word DISTINCT to the RowSource of the list box, i.e.:
SELECT DISTINCT ...
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"dvorett" <da********@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
I have a list box controlled by a field where there are multiples of
the same entry. i.e. Field Goal with 7 instances of "Erosion
Prevention". I would like to be able to have "erosion prevention" only
appear once in the list box, is there a way to automate this.
Thanks
Dan