Populating Combo List

[JMNUSS]

in Access 97

I have a form that contains a combo list of values. If
there is a value that is not in the combo list I want to
be able to enter it and have it saved so that it reappears
the next time. Is this possible?

Thanks, Jordan

 

[Wayne Morgan]

To have it appear the next time you need some place to store the value. You'll need to
change the combobox to use a table or query and store the list in a table. If you have a
sort order that you are wanting to maintain, you could have an extra field in the table
that has the sort order (i.e. 1, 2, 3, etc).

 

[Jen]

You would set the combobox's controlsource property to
point to that table.

Regards,
Jen

 

[Wayne Morgan]

You would create it just as you would any other table. Here is an example of how to add
new data once you are using a table to fill the list.

http://www.mvps.org/access/forms/frm0015.htm