Combo Box

[will]

How do I get the info not already in the combo list to be
added to the list after the first time it is entered.
Example if I have A, B, C already in the dropdown box if
i enter D in the field I would like it to be in the
dropdown list in the next record
Thanks

 

[John Vinson]

How do I get the info not already in the combo list to be
added to the list after the first time it is entered.
Example if I have A, B, C already in the dropdown box if
i enter D in the field I would like it to be in the
dropdown list in the next record
Thanks

Look at the online help, and the sample code at
http://www.mvps.org/access, for "Not In List".

 

[Ken]

<b><u>Solution 1
Error handling is perfect for this - In the combo box set
the properties to "LimitToList=True" this will cause an
error when you try to enter something that is not in the
list. At this point by recognizing the error number you
can add what they entered to the table or list box
property and refreshing the list bix. (NOte: Tables make
it alot easier that changing the property of a form)

Like most other programming there are at least 100 other
possibilities.