Combo Box lists the tables available

[MediaDoc]

Hi Everyone,

Have an interesting situation.

Client gets a new database table every 4 months (quarterly information). I have built an 'sift through this info' form that lets the users go through this table, and pull out the information they want, and put it into their database. After each record is viewed, it is archived to another table.

To start the whole process off, I would ideally like them to be able to select the table of quarterly info they would like to go through. Right now I have it hard coded for each quarter.

Is it possible to get a form list box / combo box to display the tables available to load into the 'sift through this info' form?

All quarterly tables start with FOAFDateYear, so I would like this form to search the tables objects, for any with 'FOAF' as the first 4 characters, and then list them.

Cheers,

Matts

 

[DES]

Here is a sample

Enjoy.

 

[MediaDoc]

Thanks very much, interesting code.

Im getting an error (complie error: Method or data member not found) on the .AddItem line... but I think I get the jist of it.

I will post any changes to your code if I make them.

Cheers,

Matts

 

[DES]

check

your references to the ADO. The code works if the references are right