Hi. I would like to add drop-down lists to a form. The first drop-down would have Department numbers and then the second drop-down would show a Fund code. For departments 950000-954000 the fund should be 225. For department 956900 the fund should be 569, department 957000 the fund should be 570, etc. If someone selects 956900 in the department drop-down, the only option I want to show in the Fund drop-down is 569. Is a dependent drop-down the best way to do this? If so what is the VBA code for this?