To Attend or Not Attend...THAT is the question

I am working on an event database.



Tables:

Members

Events

Attendance (MemberID and EventID from previous tables)



I have a form that selects the event and a list box shows the ATTENDING Members based on a query of a value on the form (EventID).



I'm looking for a way to take that query and run it against the Members list to show me the Members NOT currently attending.



Any ideas how to run a query based on a previous query and pump it into a list box?



Thanks in advance!

To Attend or Not Attend...THAT is the question