Pull data from query (or table) using VBA

[melody.anne]

I have a table that has four columns. Column 1 had people's names, column 2 has their email, 3 has a category, and 4 has their office.

I have a form with radio buttons, When you check a radio button and press OK it will display the e-mails for the people selected. Problem comes when it's by category, since categories are not unique to one person. I want to click the category radio button and have it display every person under that category, concatenated with a comma.

Problem is I can't make a listbox because it will show the same categories several times instead of just once, so I want the radio button with the category name on its label, and then in the code I need to tell Access to go to the table and search for the e-mails from a specified criteria, the category.

How do I do this?

 

[burrina]

So, filter the Listbox by Category.

E

xample: Using a Combobox to filter

SELECT [egroup], [egroup] FROM qryEmailClientsByGroup UNION SELECT "*","<< ALL >>" FROM qryEmailClientsByGroup;

HTH