autotext in a combo box

[Guest]

Hi! Still learning, so please be kind.... How do I allow new text to be
stored in a combo box? ie. 4 cities in a drop box, none of which is the city
I want...I type out the new city....how do I keep it in the combo box. I
want to allow all the data I enter to be saved onto that drop box. What do I
do? I'm not really technical, so please use "childlike" terms. Thanks in
advance.

Chelle

 

[Guest]

Hello,

I'm still learning too, so although this has solved the same problem for me
it might not be the simplest solution.

Create a query to run of the field that relates to cities in your table to
show all entries (set the unique record value to "yes" in the properties of
the query). Then change to control source property of your combo box to run
from that query. This way every time you add a new city when you go back into
the form the query will pick it up. Sorry if this all sounds like the long
way around but it probably is!

 

[Guest]

Thanks for replying JohnC. I will definitely try it. If you find
a more simpler method please don't hesitate to post again.

chelle