multiple selection of records

[cardgunner]

I'm building a database for a realtor friend. Part of his job is keeping track of where his clients want to live. I have added a field named "Areas". I need to populate that field with names of cities where his clients want to buy thier house. Sometimes there are only a couple of cities. Other times there could be more then 10. I don't want him to type these cities in. He is not a good typer, either am I, and he is prone to abbreviations and typos. Garbage in garbage out. I would like to provide him a drop down list, or something like that, of all the cities or areas and have him select each area and then either hit a command button or copy/paste it to that text box. Either way will work. The command button would be nifty. The result would give him the option of doing a form filter and being able to filter that text box for ex: "atlanta" and "syracuse". He then could cue these people when he has a property come available in either one of those cities.

I DON'T understand VBA code. I don't know how to write it or where to put it.

I tried to search this site and I could not find any threads like this, to my amazement. If there is a similiar post out there and I could not find it I apologize in advance.

 

[llkhoutx]

This requires programming. It's straight forward, but far from trivial. I suggest that you hire someone to do this.

You could use a multi-select list box with all possible cities, but I discourage it unless all cities are viewable at once.

Two list boxes, one to contain all possible cities and one to contain selected cities would be a good approrach. all selected cities are clearly visible. Adding, removing, and clearing selected cities from the selected and possible cities (once selected) must be allowed for, i.e. programmed. This allows user to make multiple selections, that is, not making all at one time.


A checkbox approach is also possible, depending on the total number of possible cities.