List box to (1 Viewer)

[foxtet]

Hi every one
I want list box clicked country to display it airports in the given list box and add airports to to that list for the selected country.

foxtet

 

[Ranman256]

in the cboCountry afterupdate event, reload the Airport box...
cboAirport.rowsouce = "qsAllAirports"

sub cboCountry_Afterupdate()
   if isNull(cboCountry) then
       cboAirport.rowsource = "qsAllAirports"
   else
       cboAirport.rowsource = "qsAirports1Country"
   end if

the qsAirports1Country query uses the cboCountry in its query.

 

[foxtet]

Thank you.
cboCountry is not used. I have used a list box and text box only
text box is for search.
lstCountry list box is for search result
lstAirports list box is for airports of the clicked country in lstCountry

I also want add airports to lstAirport is desired airport is not available.

foxtet