get a combo box to show specific list depending on data eneterd

[Guest]

im designing a database that a user has to enter his personal information in
it, including his country of birth and city of birth i want the user to
select a country from a combo box and after the country is selected only the
list of cities that are in that country would appear, i have 2 different
tables for the cities and countries liked together with an id number that
links a city to its country but i cant get the combo box to keep updating it
self when the user is entering another record for another person the list is
stuck on the country entered in the previouse record

 

[Steve Schapel]

Haitham,

Do you have this set up so that the Query that serves as the Row Source
for the City combobox, has a reference to the Country combobox in its
Criteria? If so, put code, the equivalent of this...
Me.City.Requery
.... in the After Update event of the Country combobox.