[AccessD] A2K: Populate List Box

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





More information about the AccessD mailing list