Tables collection

[markhirt]

Hey there! I'm trying to iterate through the table and properties of the tables within my *.mdb project.

I thought I could use the AllTables collection, but I'm having difficulty.

I need to populate combo boxes with:

1. Names of the tables in my project.
2. Fields within selected combo box value of #1.

For some reason getting my hands programatically on the correct collection is proving to be quite difficult.

Please help.

 

[WildHare]

There is a small example db on my website that does just exactly this. Look for the tablefields sample database

http://www.jmhare.com/wildhare2.htm

Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Neat Access stuff at

http://www.jmhare.com/wildhare2.htm