Populate a combo box with feild names from a table, using DAO 1

[Iainkerr01]

I am trying to create a form for users to generate their own query. To do this I need to be able to populate a combo box with the available field names wither from an existing table or form an existing query.
Any help on this please?

 

[Ed2020]

Set the RowSource of your combobox to the name of the table and set the RowSourceType to "Field List".

Ed Metcalfe.

Please do not feed the trolls.....

 

[dhookom]

There is a complete "applet" using this functionality at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]