BASE Switching datasources for Combobox?

[gkick]

Hi,

I make heavy use of reference tables to fill list boxes embedded in table controls. See images. Now while not really a problem, but in cumbersome - if a user needs to add another item to one of the lists, he needs to switch to the reference table maintenance form, select the desired table, add a new record and then switch back to the actual contact input form, refresh it and then assign the newly entered item.

As an alternative if thought of perhaps using combos instead but they show a blank on opening rather then the actual value of the underlying table whereas one can not add new records to a list box I am made to believe.
As such I was wondering if it should be viable to have one combo box to change any of the list boxes where the underlying field has a unique index to avoid duplicates.

This would necessitate switching the record source of the combo box by
double clicking on lets say the country list box to activate the change of record source to the tblCountry, add the new value into the blank, press the enter key to refresh the calling list box contained in a sub forms table control

Appreciate any ideas, thks

[Ratslinger]

Hello,

Seems you may be missing some basic understanding of the combo box. This is to allow the entry of an item other than what is on the list. It adds it to the record it is attached to and not the table from which the list was generated.

To add items to this originating table requires macros for each specific table to be updated. For a simple example, see this post → Add entries to listbox or combobox

[gkick]

Guilty as charged, you are right, am Access pre conditioned where a combo is a combo , takes some time to come to grips with some of the strange things in Base.
Thanks anyway for the link.