Insert into location_view(lo_address lo_city,; lo_state,; lo_zip,; lo_country); values(Thisformset.Form2.txtAddress.value,; Thisformset.Form2.txtCity.value,; Thisformset.Form2.cboState.value,; Thisformset.Form2.txtZip.value,; Thisformset.Form2.txtCountry.value) Messagebox("The New Co-location is added into the databes",; 48, "Addition Message")When the users enter a new location_city that doen't exist in combo box, they need to add this new. They go to Form2 to add the new location then come back Form1. At this time, they drop down the combo box the location_city and location_id should be in there already. The problem is the location_id in combo at this time is 0 always. Now, the location_id (automatic number) just returns to correct value if the user exist either this form and log off the application then log in application and run form again. I want the location_id in combobox would be correct value when the users go back Form1. I hope how I explain my problem could be clear. I believe somebody here can hepl me to solve this. All suggestions, tips or ideas would be appreciated. Thanks in advance.