Populate combo box with column names of table
Posted on 2005-05-03
I need to populate a combo box (combo31) with the column names of the table chosen in another combo box (combo1). I can go into the properties of Combo31 and choose a row source type of "Field List" and then enter a table name for the Row Source but that leaves the column names only being populated by the table entered. I need something that displays the column names based on the value chosen in combo1. I tried things like entering "me.combo1.value" in the Row Source box but no luck.
Any ideas??? Thanks!