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 action on
LstCitySource. Any help on solving this puzzle will be appreciated! Thanks! I
hope I explained it so it not confusing!
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 action on
LstCitySource. Any help on solving this puzzle will be appreciated! Thanks! I
hope I explained it so it not confusing!