Conditional list table

[josnow]

I have created a form with two tables. One table is the SOP table which includes the following: SopId, SopName, SopLocation, RoleId, SopOwner, etc. The second table SopReviewer includes SopReviewerId, SopReviewerName, RoleId. I want to put a List Box in my form which will shows the SopName, SopLocation, RoleId and SopReviewerName by RoleId. I want the SopReviewerName to be a List Box that shows only the records from the SopReviewerName on the SopReviewer table in which the RoleId from the SOP table (also the RoleId on the form) equals the RoleId on the SopReviewer table. How would I make this happen in which I can only chose those SopReviewName by RoleId from both tables? Also, once I have the code, where would it go on the form?

[June7]

What do you mean by 'a form with two tables'? Both tables are included the form RecordSource. Doubt this will work. Sounds like you need a form/subform arrangement. Review http://office.microsoft.com/en-us/ac...010098674.aspx