Table Combo Box - Row Source Table/Query

[jsic1210]

I am trying to create a combo box in a table that looks up values from a query. The table I am working in is: tblNotices. I want it to look up the query qryFirstLastName. In qryFirstNameLastName, each COID (customer ID) has up to three different RecipientNames. So in a record, I want the combo box to display the three RecipientNames based on that record's COID.
Example: qryFirstNameLastName shows:
COID RecipientName
1111 John Doe
1111 Jane Doe
1111 Bob Smith
12345 John Public

In tbl Notices, if the current record's COID is 1111, I want the combo box for RecipientName to ONLY show John Doe, Jane Doe, and Bob Smith (not John Public).
Can I do this an SQL?

 

[rodmc]

I am trying to create a combo box in a table that looks up values from a query. The table I am working in is: tblNotices. I want it to look up the query qryFirstLastName. In qryFirstNameLastName, each COID (customer ID) has up to three different RecipientNames. So in a record, I want the combo box to display the three RecipientNames based on that record's COID.
Example: qryFirstNameLastName shows:
COID RecipientName
1111 John Doe
1111 Jane Doe
1111 Bob Smith
12345 John Public

In tbl Notices, if the current record's COID is 1111, I want the combo box for RecipientName to ONLY show John Doe, Jane Doe, and Bob Smith (not John Public).
Can I do this an SQL?

#
a combo in a table is a no no, use combo's only on forms, plus as many here will tell you that user should not be allowed root access to your tables, which it sounds as if you might be doing