I have a form with a combo box on it it is set to look up a record. all this works fine except being based on a table the list gets very long. (call it Property list) it looks up the names of buildings

I would like to have a second combo or list box (Call it Department as it has all the departments that the buildings belong to) that would allow the record selection combo to only list items appropriate to the selection selection of the second combo box. I have set up a second combo which works fine am triing to set that as the criteria for a querie that will select based on results in the second combo. Thus far with no success. the quire works but not the property combo

I would be grateful for any hel

Kind Regards

Morgan