Help with Join, Union

I have a table with a field named Events.
In this field is events like Bowling, Concert etc..

The next field has people who are going to the Events and some people will be going to multiple Events.

The problem is I need to list each Event and only those people associated with each Event they are going to.

Right now I get this when I create a query:

Event Name

Bowling Bob
Bowling John
Concert Bob
Concert John



I would rather list them as Events related to Names.
In VB6 I have a dataCombo that lists the Events and Names
But I need the DataCombo to show an Event and all those Names that have that Event with it.

Right now the datacombo has the Events seperately with each Name.

How can I query for each Name as related to Event ?

Thanks !

you have one table with Event&Name in it?

select name
from tableName
where Event=?