Hello. I have a table called "candidates" where I want to store candidates information along with his location. I have another table of "location" which has data of all cities and countries. I have developed a form for data entry. I want whenever a user click on a city in bombo box, its country will automatically be selected from "location" table and show the information on country's text or combo box in a form. What and where I have to run a vb code to show selected country information. How can I do this?