I'm trying to document a number of queries run on a set of linked tables.
These queries standardize field names and perform various data conversions,
and I then open them as recordsets to populate another set of tables.
Because the queries make considerable use of VBA function calls to build
expressions, I was hoping I might somehow be able to write this information
out to a text file along with the properties I'm familiar with. In other
words, if I can get this ....

For Each fld in rst
      Debug.Print fld.Name, fld.Type, fld.SourceField, fld.SourceTable
Next var

...is there any way that can I add the expression/function call to this
list. I assume I need some whole other object to get at it (if such an
object exists), but nothing I've tried so far works. I can, of course,
output the SQL string and then parse the expressions/function calls
field-by-field.

But is there a simpler way?

Thanks.

Patrick Bold