Why does this:NOT return the same as this:Code:For i = 1 to db.TableDefs(0).Fields.Count List1.AddItem db.TableDefs(0).Fields(i-1).Name NextEven 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.Code:For i = 1 to db.TableDefs("Table1").Fields.Count List1.AddItem db.TableDefs("Table1").Fields(i-1).Name Next![]()




Reply With Quote