Why does this:
Code:
For i = 1 to db.TableDefs(0).Fields.Count
     List1.AddItem db.TableDefs(0).Fields(i-1).Name
Next
NOT return the same as this:
Code:
For i = 1 to db.TableDefs("Table1").Fields.Count
     List1.AddItem db.TableDefs("Table1").Fields(i-1).Name
Next
Even though table1 is the first table in the database and I thought would equal tabledef(0)? When I use the tabledef(0) I only get half the fields that are in the four field table. I'm very confused, especially since one of the field names returned isn't even in the table! Please help me out.