I have a combo box (cbo1) that has values from another table. I then have a textbox that has a dlookup expression that looks up the value in the combobox (cbo1). That part works fine until I select another combobox or checkbox the result from the dlookup of the textbox changes to #Value! every single time. It will not hold the dlookup result. (cbo1) still has what the user selected, but like I said the textbox dlookup goes to #Value! What am I missing here?