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