Listing column names in combo box. How??

[javanic]

Hi. I'm quite new to Access programming, so please bear with me.

I would like to fill a combo box with the column names contained in a table. The user would select a column name and then fill in a text box to create a query. How can I fill the combo box with just the column names/headings of a table?

Thanks in advance,

javanic

 

[jebry]

Hi javanic!

You can make the rowsource type Field List and the rowsource the name of the table you want to list from and Access will do the rest.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[javanic]

Man, some things sure are easy! I wish it were all like that. Thanks.

javanic