I have a form containing a combo box which is a contract number. What i am trying to do is find a record in the contracts table based on the contract number selected from the combo box and then update the record in the contract table with a value from the current form. The current form is not based on the contracts table it is based on a query on a table called allocaions. Any help would be gratefully received... Thanks..