Query to Build List of Existing Fields in a Table

[Joe User]

This may sound silly, but is it possible to build a query to generate a list
of fields in a given table?
TIA

Joe

[Douglas J. Steele]

Assuming you've got a reference set to DAO, something like:

Dim dbCurr As Database
Dim tdfCurr As TableDef
Dim fldCurr As DAO.Field

Set dbCurr = CurrentDb()
Set tdfCurr = dbCurr.TableDefs("MyTable")

For Each fldCurr In tdfCurr.Fields
Debug.Print fldCurr.Name
Next fldCurr

Set tdfCurr = Nothing
Set dbCurr = Nothing

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Joe User" <jo*@user.com> wrote in message
news:bu**********@tribune.mayo.edu...

This may sound silly, but is it possible to build a query to generate a list of fields in a given table?
TIA

Joe

[Trevor Best]

On Fri, 16 Jan 2004 14:46:31 -0700 in comp.databases.ms-access, "Joe
User" <jo*@user.com> wrote:

This may sound silly, but is it possible to build a query to generate a list
of fields in a given table?

Is this to display in a combo box? If so then set the RowSourceType to
"field List" and the Rowsource to the name of the table.

--
A)bort, R)etry, I)nfluence with large hammer.