dynamic list of tables and fields in those tables

[cls3152]

what i'm lookin for is probably some kind of For...Each thing that will first scroll through the database and put the names of all the tables into a combobox in a form. (i think i already have that one figured out), but then i want to pick a table in that box, and then have a 2nd combobox fill up will all the fields that are in the table that was chosen from the 1st box. that's where my problem lies. the 2nd combobox always ends up blank.

 

[gol4]

set combo2 RowSourceType to field list

then in the after update event of combo1

Me.combo2.RowSource = combo1.Value

 

[gol4]

as an after thought

are you using

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],4) <> &quot;Msys&quot AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name

as combo1 rowsource to get your table names?

it is my prefered method