This is the schema : 1 table CONTRACT and 1 table CLIENT. A foreign key of CLIENT in CONTRACT). On one form I show all contract information including the foreign key which is a combo link to the CLIENT TABLE. The problem is : I click on a button to open a new form to create new CLIENT. BUT when back to CONTRACT, the combo is not updated. If I close the CONTRACT and reopen it, i'm back to the default value on the form and need to search the contract i'm working on. If anybody has any idea on how to solve this. I'l be pleased. Thx

If I understand your question correctly, you need to build a form that is built on a query that includes all the fields from both tables. Then when you update the field on the form it will be reflected in the corresponding table. Larry