>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
I believe you can reload the ListBox - clear it, and use AddItem() to add the items one at a time. Another option - if you prefer to bind the ListBox to a table or cursor - would be to set a filter, or to re-select the cursor.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
