Joshua B
lists at jbsolutions.com.au
Fri Jun 20 02:51:17 CDT 2003
Hello Darren DICK, I think using the "NOT IN" syntax should do the job.. Without knowing the exact structure of your tables, I would say it would be something like... "SELECT * FROM tblAttendees WHERE AttendeeID NOT IN (SELECT AttendeeID FROM tblRegistration WHERE EventID = " & Forms!frmEvents.EventID & ")" ======= At 2003-06-20, 16:43:00 you wrote: ======= >Hello all >This should be simple. But it is p***ing me right off. >I have an Events form called frmEvents. Bound to tblEvents. >2 list boxes on this form. The one on the left lists available clients >The list box on the right is showing people who are registerd into this event. (Attendees) >This is stored in tblRegistration. AttendeeID with EventID and RegistrationID. >(All the names of attendees are got from the tblAttendees table) > - Pretty basic sofar. >Double click on left box to 'Register in to the current Event' >Double click on Right box to 'un regsiter' - Rocket science. >The lists grow and shrink accordingly. > >But here is the problemn >In the list on the left I only want to show people who are not registerd into the current event. > >I am having a 101 moment here (Drew) > >Any help?? > >Darren > > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com = = = = = = = = = = = = = = = = = = = = Best regards. Joshua B lists at jbsolutions.com.au www.jbsolutions.com.au 2003-06-20