Multiple Listbox issue

E

Ed Lawrence

HI! I have a subform that has the following
listboxes:LstStateSource,LstStateDest,LstContySource,LstCountyDest,LstCitySource,LstCityDest,LstZipSource,LstZipDest.
All the "Lst*Source Listboxes are connected to a zipcode table. The Lst*Dest
boxes displays the table info for that record. Example:TblCity,TableState
etc... Anyway, What I would like to do is if the user picks a state in
lstStateSource, then all the cities,counties and zipcodes associated with
that state are saved to the tables. The same if county is selected in
LstCountySurce Listbox.It would then save all the cities and zipcodes
associated with that county in the proper tables. The same thing goes for the
LstCity.Any help on solving this puzzle will be appreciated! Thanks! I hope I
explained it so it not confusing!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top