Get value from dao.field

[Ruegen]

I have a loop



For Each aField In aTable.Fields


next afield


I want to put the table's field value in an array

redim preserve myarray(0 to x) as variant
myArray(x) = aField.value
x = x + 1

however whenever I put afield.value down I get an error and I can't even debug.print afield.value


suggestions?

[Ruegen]

Wait nevermind... answered my own question...

you can't