I have a series of cascading comboboxes which work as expected. The second to last combo shows data for the rooms on a particular floor. The last box then shows what desk numbers have been added to that room. How could i change this last box to only show desks that have not been assigned to personnel? The filter i have behind the cboDeskNumber is:
[forms]![frmPersonAdd]![cboRooms]