Populating a combo box with field names.

[Clay Reitsma]

I want to populate a combo box with a list of all of the field names in a
database (ie. more than one table). I want the user to be able to select any
field name to be used in an on the fly query. Does anyone know how to do
this? I am using MS Access 2000.

 

[Allen Browne]

This would require you to loop through all TableDefs, and output the Fields
collection of each.

There is an example of outputting the fields of one table in this link:
http://allenbrowne.com/func-06.html