How do I populate list box with field names of a table?

[Nevets]

I am trying to build an interface to allow users to select which fields from a specific table they wish to include in a query.
For some reason I am stumped on trying to figure out how to get the field names of a table, rather than it's records to populate the list box. Can anyone help?

The next step will be to pass the selected fields to a SQL statement... but I'll fight that part of the battle when I get to it.

 

[PHV]

Set the RowSourceType property to Field list and the RowSource to the table name.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Nevets]

Thanks. I had the feeling I was missing something fairly simple.