Hi, Thanks for your replies.
What method do I use so that I can run some code when a user is scrolling down the Country Listbox
i.e. when I change from country to country(in the country listbox) , i want to be able to run the code which just selects out that country's cities and requeries the City listbox, but dont know waht method/event to use
regards,
gerard


>Hi Gerard,
>
>>I have two listboxes on a form, say a Country and a City.
>>When I go up down the country ListBox, I just want to show the cities relevant to the specific country
>>My List Boxes come from a Country and City table, the City table also having its parent (the Country) as one of the fields.
>>
>>How do I get the Cites to display on the listbox, but just those relevan tot the country that is currently highlighted.
>>
>>Thanks in advance.
>>regards,
>>Gerard
>
>Listboxes use .Requery instead of .Refresh.
>So, you could start a method, that reads the city-cursor after selecting a country and then make a .Requery to the city Listbox.