By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

Combo Box Wizard

P: 25
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!
Sep 12 '07 #1
Share this Question
Share on Google+
3 Replies


JConsulting
Expert 100+
P: 603
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!
You have it exactly right. tying a control source to a combo box means that whatever bound column is identified in your combo, gets saved to the field you put as the control source. This option is also available at the table level by developing a "Lookup" field and defining the field type as Combo box.
J
Sep 13 '07 #2

ADezii
Expert 5K+
P: 8,638
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!
Or is it simply the Control source property with "unbound" being the "remember for later" option?
You basically answered your own question.

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.
Sep 13 '07 #3

P: 25
Thank you both for your replies.

Very Helpfull!!
Sep 13 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.