Manage Lists for Combo and List Boxes

[CanWest]

So I have been working on this project for about a month now. It is almost done.

During the course of it's development I have created about twenty tables whose sole purpose is to house data for use in combo and list boxes. They have no other purpose.

I am now in the process of creating the maintenance side of this project and I am wondering if anyone has any insight on how to manage these lists. In the past I have created a form with a multitude of subforms to manage these lists.

Just wondering if someone has a better even more elegant way to do this.

 

[CJ_London]

sounds as good a way as any.

As an alternative you could just have one combo to list all theses tables. and a single sub form which you would assign the table name to the controlsource in the combo afterudate event.

Assuming you have some structure to your table names like tblListA, tblListB etc you could base the combo rowsource on a query on the MsysObjects table

SELECT [Name] FROM MsysObjects WHERE [Type]=1 and [Name] Like 'tblList*'

Then in the combo afterupdate event just have

SFormLists.sourceobject="Table." & comboname

change names to suit the names of you controls