Limit Combo Box Selection

[SMT]

I have a event form which has an attendees subform that contains a combo box
with a list of all employees. When an event data is initially entered a list
of employees attending that event are selected from the combo box on that
subform. Once the event is complete I have another subform for ranking the
event. I have an attendeeID combo box on the ranking form that I would like
to limit to just those employees that were originally selected as attending
the particular event. How can I do this? All those in attendance do not have
to fill out ranking. Thanks

 

[SMT]

Yes, one would go to the form at different times. I am saving the results of
the attendees selected in a tblIntersection, a junction between the tblEvent
and Author (which contains EventID, AuthorID, IntersectionID). On the Ranking
subform I have a combo box that right now pulls up ALL the attendees listed
in the tblIntersection (See below.) I feel like I am missing something really
easy here but its just coming to me. I appreciate you assistance.


SELECT DISTINCT Author.Author, Author.AuthorID FROM tblEvent INNER JOIN
(Author INNER JOIN tblIntersection ON
Author.AuthorID=tblIntersection.AuthorID) ON
tblEvent.EventID=tblIntersection.EventID;

 

[SMT]

I got it working properly, thanks!

I'm a little confused by the SQL because I don't know the background. Maybe
you could try this to bring it down to an understandable place:

Create a query in the Query Designer, Filter it on the EventID (or filter it
on the EventID from the form somewhere if it is there: =form!thisform.
EventIDfield) Show the Attendees in your fields and view it. See what is
missing/wrong. If you can get it here, copy the SQL code to your combobox.

Bonnie
http://www.dataplus-svc.com

Yes, one would go to the form at different times. I am saving the results of
the attendees selected in a tblIntersection, a junction between the tblEvent
and Author (which contains EventID, AuthorID, IntersectionID). On the Ranking
subform I have a combo box that right now pulls up ALL the attendees listed
in the tblIntersection (See below.) I feel like I am missing something really
easy here but its just coming to me. I appreciate you assistance.

SELECT DISTINCT Author.Author, Author.AuthorID FROM tblEvent INNER JOIN
(Author INNER JOIN tblIntersection ON
Author.AuthorID=tblIntersection.AuthorID) ON
tblEvent.EventID=tblIntersection.EventID;

Couple of questions:

[quoted text clipped - 14 lines]

the particular event. How can I do this? All those in attendance do not have
to fill out ranking. Thanks