I have a form with fields bound to table1. Field1 is a combo list that is populated by values from field1 in table2. Tsble2 has other fields that correspond to fields in table1. When I am adding a new record in talbe1 and select a choice in the field1 combo list that would have the same value in field1 in table2, I would like to have the corresponding values from the corresponding table2 fields to appear in the form but not necessarily accepting the values before I commit the record to the table. How do I accomplishthis? I am new to VBA.