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.
Best Regards
-Tom
Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.
Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011