I need to fill in a field on a form(A) with data . This data comes from another table(C) and the data that is used to fill in this field depends on a combo box on form(A). Form(A) is based on Table(B). The combo box is based on Table(C). What happens when I enter a new record and the cursor is in the combo box field is that the field that I need to be filled in does so when I choose the combo box. However, if I first go to the field that is my primary key and fill that in and then go to the combo box, the field I need to be filled in will not fill in. Any suggestions owuld be greatly appreciated.