Mulitiple 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.

 

[alastair69]

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.

you can use either a sub form to show the results from a query. can you post the database and i will show you at least two ways of doing want you want to do.

Alastair

 

[cardgunner]

I tried to attach it. I don't have the list of all the areas yet.

 

[alastair69]

I tried to attach it. I don't have the list of all the areas yet.

I will try to type you though it. You will need to create a table for your areas to be entered and your cities then do the following.

1) You need to create a new query in design view.

2) Select the table thats is holding your data (Your case Areas & Cities)

3) In your "Area" box you will need to type the following
[Forms]![Main Form Name]![If sub form is used Name in here]![The
actual form name here]![Field Name Here]
i.e [Forms]![Main Form]![ContactSub]![frm Contact]![Area]

4) Run the query it should ask you for an "Area" name or what ever you
called you text box on your form.

5) Query should bring up just the records relating to your "Area" seleted

I will try and make a little db for you to follow.

 

[alastair69]

You have a table called "Prospect Table" and a field name of "Area", this has a line of information (example: Syracuse-West, Westhill, Onondaga) i am not sure wether these are "Areas" or citys. can you confirm that they are areas or cities for me.

 

[cardgunner]

They are both. Westhill is a city but Syracuse-East is an area.

 

[cardgunner]

I'm not sure if we are onn the same page. I will try to explain it the best that I can. My Fiend "Judy" who is a realtor is trying to compile info for her reality business. She asks her clients what areas are they interested in. She then has to type these areas into the form in the text box provided. However she also has other people using the same database. So she may type in westhill as "westhill" or Whill or W-Hill. I want to give her a list of areas and then she can click the ones she wants holding down the control key and either select copy or hit a command button which would then take her selected records and fill in the text box with these records seperated by a comma or spoecae or something.