If im understanding you correct ... you want two combo boxes to communicate with each other ... when you change one it narrows the results in the second combo box? if this is what you want then you need to go to the second combo box and go to rowsource under data and click the "...", then go to...