the problem with cbo1 is that no matter what I do, I cannot get it to update as the record changes. Ideally, as a record change occurs, it should be able to take the current InternalIncidentID and update the ClassificationType appropriately. This would require a join via tblClassifications I thought, but I can't get that to actually update. Basically when the record changes, I need cbo1 to look at the value in cbo2 as it changes and then update accordingly.