Populate one listbox from the values in another

C

cfuhrhop.patterson

I have a list box (Results) that displays the (Name) values in (Table)
that correspond to the user defined (Heading) value from (Inputbox).
I would like to populate another list box (Altresults) with the values
from (Table) that have identical (Name) values, but different
(Heading) values as any of those in the (Results) list. I have an
attempt at an sql for (Altresults), but the problem is that it only
works with whatever value in results is selected, and I want it to
work for any item in (Results).

SELECT Heading, Name FROM Table
WHERE Name=forms!Searchform!Results
AND Heading<>forms!Searchform!Inputbox.text

Thanks for any help.
 
Top