Quote:
Originally Posted by teric2
I have developed several Access databases for my company so, I'm not exactly new but I have a simple question.
If you create a Combo box using the toolbox menu bar. The wizard appears. One of the options the wizard asks is whether you want to store the selection from the combo box in a table or have Access remember the selection for later use.
Once the combo box has been created where in the properties can you go to change this? Or is it simply the Control source property with "unbound" being the "remember for later" option? And if I set the control source to a field and allow users to type something new into the combo box instead of selecting from the list will what they type appear as a new entry in that table/field?
Thanks!
Quote:
Or is it simply the Control source property with "unbound" being the "remember for later" option?
You basically answered your own question.
Quote:
And if I set the control source to a field and allow users to type something new into the combo box instead of selecting from the list will what they type appear as a new entry in that table/field?
If the Limit To List Property is set to NO, the New Value will appear in the Field designated as the Control Source but will not appear in the Combo Box drop Down Menu. To do this, you must programmatically add it to the Record Source of the Combo Box via the NotInList() Event.
