I have 2 tables, one has company info including a fee field. Then I have a table with inspections that include the company and the fee for that company. I have a form which I enter new inspections in. I have a combo box that I choose the company for each inspection. What I want to happen is the fee for the company I just selected to be put into the inspection fee field. I have tried using the setvalue function in a macro but I keep getting automation errors. I have a query that will select the fee from the company in the inspections form. So I have the value but I do not know how to get it to automatically show up in the inspection form [fee] field. Please help! I have been messing with this for months.