Listbox vs combo box

[Guest]

I have tblCity that has 200 cities listed and tblTaxi that lists the taxi
companies. A taxi can serve many cities so I created a link table called
tblAreaServe that links both tables. Below is an example:

tblTaxi
TaxiID TaxiName
1 ABC
2 DEF
3 GHI

tblCity
CityID CityName
1 Los Angeles
2 Burbank
3 Hollywood

tblAreaServe
ASID TaxiID CityID
1 1 1
2 1 3
3 3 2
4 3 3
.....

In the form, I have a subform that displays the tblAreaServe as a datasheet
with a combo box that lists the cities. So, if a taxi serves 100 cities, the
user has to create 100 records. I want each city recorded because the user
will do searches based on the cities.

This can be cumbersome to do...manually choosing a city, going to the next
line, choosing the next city...etc

The user first wanted me to have each city be a checkbox (easier to click
and unclick). No, I said, very inefficient.

I thought of a workaround:

Can I have a listbox instead of the combo box. Set the multiselect to
Simple. The user can choose as many cities as they want. When they save the
record, I have a code that updates the tblAreaServe with the cities they
chosen. Maybe have a Do Loop function or something.

This way, the user gets the ease of use...and I get the tblAreaServe.

Thanks.

 

[MacDermott]

Good idea!
I think you'll find some code to do this, if not right in the Access Help
file, then at www.mvps.org/access.