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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Clay Reitsma" <rr******@shaw.ca> wrote in message
news:FcPLb.44316$X%5.11081@pd7tw2no...

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.