I'm trying to autofill a textbox (txtdeptname) based on the value in a combobox (combodeptnum). I have a department table that has the info in it (dept_num, dept_name). I tried DLookup, but it keeps giving me an error that the "Object doesn't support this property or method". Thanks in advance for any help!!