Loop thru tabledefs in CurrentDb 1

[biot023]

Hallo.
Does anyone know how to loop through the tabledefs in the current database?
I tried

Dim tbl as Tabledef
For Each tbl in Currentdb
...
Next

but it says that the object (tbl or CurrentDb) does not support this operation.
Is there another way, or am I just totally misunderstanding the whole For Each... Next thing?

Cheers,
Douglas JL

If it don't make you laugh, it ain't true.

 

[Taff07]

just add .tabledefs onto the currentdb.

It will then look like:

For Each tbl in Currentdb.tabledefs

.....


Next

Hope this helps

Ian

 

[biot023]

Simple (I can understand it) & effective (it works)!

Thanks alot, man!

Douglas If it don't make you laugh, it ain't true.