Populating Combo List

  • Thread starter Thread starter JMNUSS
  • Start date Start date
J

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
 
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).
 
You would set the combobox's controlsource property to
point to that table.

Regards,
Jen
 
Back
Top