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

Lookup Tables/combo boxes

P: 2
Hi all,

I am having difficulty adding to a lookup table; I want to be able to use a combo box to enter predefined values in a form/table, but also enter new values in that combo box. The dificulty is that the new values don't show in the combo box so that they can be selected auto the next time around. I have tried some code in the 'On Not in List' source properties, but I have small-average coding knowledge and hence have been unable to find a solution. Can anyone help?
Dec 21 '07 #1
Share this Question
Share on Google+
3 Replies


Minion
Expert 100+
P: 108
Hi all,

I am having difficulty adding to a lookup table; I want to be able to use a combo box to enter predefined values in a form/table, but also enter new values in that combo box. The dificulty is that the new values don't show in the combo box so that they can be selected auto the next time around. I have tried some code in the 'On Not in List' source properties, but I have small-average coding knowledge and hence have been unable to find a solution. Can anyone help?

Couple questions come to mind here. First being what type of lookup are you using for the combo box? Is it pointed at a table for it's values or are they in an embedded list?

If it is a static list that you wish to add values to it can be done with a bit of coding. Though, I would have to throw something together as a lot of my knowledge is learned on the fly, but I know it's there. Either way it should be a simple matter to have the new values added to the list.

- Minion -
Dec 21 '07 #2

P: 2
Couple questions come to mind here. First being what type of lookup are you using for the combo box? Is it pointed at a table for it's values or are they in an embedded list?

If it is a static list that you wish to add values to it can be done with a bit of coding. Though, I would have to throw something together as a lot of my knowledge is learned on the fly, but I know it's there. Either way it should be a simple matter to have the new values added to the list.

- Minion -
The list of parts is in a lookup table created in a table, where I have entered the list data in the lookup myself. As new parts are enetered via a form, I would like them to show up in the combo box so that I don't have to go to the properties/lookup and add each time a new part is added.

Thanks for your reply (sorry I think my previous post submitted accidently with nothing entered)
Dec 21 '07 #3

NeoPa
Expert Mod 15k+
P: 31,419
You need to call a .ReQuery of the ComboBox control after you add an item. This will give it a chance to regrab the data from the table into the control.
Dec 21 '07 #4

Post your reply

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