Getting Field names from a Qwery statement 1

[TheKing]

I have a VB program that I need to get the field names from an Access database.

I wrote a SQL statement to bring in some fields that an end user can chose from, I would like to populate a list box that comes from the field names. How do I extract the field names from my Qwery.

Then after I figure that out how to make the name of the field something the end user can understand for exp: 'CAS' in my field stands for 'Case Number'. I know in Access you can have a 'ghost table' behind the visible table and link the two. How do you do that in VB?

TheKing

 

[wmd3]

Well, to get field names...

-------------------------

[Recordset].Fields([Index]).Name

-------------------------

That should answer your first question.

- Bill