By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Fill ComboBox items with FieldNames from a Table?

P: n/a
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.

Aug 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
in the Properties box, set the combo box control's RowSourceType property to
Field List, and set the RowSource property to the name of the table you
want.

hth
"mike11d11" <mi*******@yahoo.comwrote in message
news:11*********************@n13g2000cwa.googlegro ups.com...
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.

Aug 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.