How to make a Column in Access a DropDown

**JohnGrove** · 03-09-2009, 10:51 AM

I am creating some tables with some questions and I have another row where the Answers are [A, B, C, D]

How do I make the column have a dropdown for these items?

**RuralGuy** · 03-09-2009, 07:21 PM

It sounds similar to a survey. Maybe this link will give you some ideas.

**JohnGrove** · 03-09-2009, 08:13 PM

Originally Posted by RuralGuy

It sounds similar to a survey. Maybe this link will give you some ideas.

Thank you.

**thhui** · 03-10-2009, 05:09 AM

It is the case for using Lookup fields in Access Table.

See the following article from the Microsoft Access Support Website:-

ACC2000: How to Add Lookup Fields in a Microsoft Access Table
ACC2000: How to Add Lookup Fields in a Microsoft Access Table

**RuralGuy** · 03-10-2009, 07:56 AM

Originally Posted by thhui

It is the case for using Lookup fields in Access Table.

See the following article from the Microsoft Access Support Website:-

ACC2000: How to Add Lookup Fields in a Microsoft Access Table
ACC2000: How to Add Lookup Fields in a Microsoft Access Table

In that case have a look at this link as well.

The Evils of Lookup Fields in Tables

How to make a Column in Access a DropDown

Thread Tools

How to make a Column in Access a DropDown

Similar Threads

Adding new column to make-table query

inserting values in column based another column

2 different fields into 1 column by query?

Drop Down, link to another dropdown

How do you change the column colors in an Access graph?

Posting Permissions