Need to populate combobox with fieldnames from a table.

  • Thread starter Thread starter mike11d11
  • Start date Start date
M

mike11d11

I'm trying to create a combo box that has the only the field names from
a table in it and not the items in that field. So for example I have a
table with 40 fields in it like Account#, Name, address, phone # etc...
I want to click on the combo box and have the option to choose a field
and not the data within the specific field. So when I click the drop
down it will show all the fields in the table (Account#, Name, address,
phone..) I've tried a few different idea's from people but cant get
it to work. I'm using Access 2002 if that helps.
 
nevermind I found a property setting within the combobox for "field
list" for the recordsource. and then based the combobox off a queries
selecting all the fields from the table I want and now it works perfect.
 
Back
Top