Building a Listbox from a field in a table

[f5snopro]

I have a form (frm_choose_owner) with a listbox which I would like to dynamically build based on the values in a specific field in a table (tbl_ITMS_dump)I have. Trick is, I don't want duplicates in the listbox.

The values dynamically added to the list box will allow the user to select on and then it will be passed to a query.

 

[ssecca]

Your row source for the combo should look something like this...

SELECT tbl_ITMS_dump.username
FROM tbl_ITMS_dump
GROUP BY Table1.username
HAVING (((tbl_ITMS_dump.username)=[Forms]![frm_choose_owner]![Text4]))
ORDER BY tbl_ITMS_dump.username;

Where I have user name just put in the name of the field in your table.

good luck
ssecca

 

[f5snopro]

Got it working! Thanks so much!