Synchronizing Multiple Combo Boxes In Access

[Rmck87]

First of all, there is probably an answer somewhere around here, and i apollogize for the inconvenience. But, i havent been able to find one anywhere that suits my desires, if there is one that would solve this problem please direct me there.


Now, i have a form with an option group(sortbybox) and 5 combo boxes(combo48, combo50, combo52, combo60, and combo62) all in the same continuous form. The options in sortbybox are set up so whenever one option(lets say 'member_ID') is selected a combo box('member_id') is disabled. But now i need to synchronize the 4 other combo boxes('Project_id', 'company_name', 'Date_start', and 'Date_end') so that when one project in 'project_id' is selected, only the company's(company_name), starting dates(date_start), and ending dates(date_end) are corresponding, one with the other. If this is possible, please let me know. As soon as possible. Anyone?????????
Thanks in advance!

rmck

 

[Rmck87]

This was an idea i had, but im not sure how to link it from one combo to another combo.


Me.Filter = "[dbo_member.member_id] = '" & Combo48 & "'"
Me.FilterOn = True


Does anyone know how to do this? HELP!!!!!!