Lookup Tables/combo boxes

[Garrystone]

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?

[Minion]

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 -

[Garrystone]

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)

[NeoPa]

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.