Field Names from Queries

[ShaneBrennan]

Does anyone have a simple piece of code to view/display the names of fields generated by a cross tab query? I wish to place them into listBox on a form - so the user can select which set/series of data he/she wishes to update.

Thank you.

Shane Brennan



Shane Brennan
Shane.Brennan@tcat.ac.uk

 

[Qaroven]

Well, assuming you use a Recordset object (eg oRst),
could do

oRst.Fields(<field name or number>).Name


Ben
+61 403 395 052

 

[ShaneBrennan]

Thanks Ben

This has been extremely useful!

Shane
Shane Brennan
Shane.Brennan@tcat.ac.uk