totn Access

MS Access 2013: Populate a combo box with a list of values (not from a query)

This MSAccess tutorial explains how to bind a combo box with a list of values that are not from a query in Access 2013 (with screenshots and step-by-step instructions).

Question: I've created a combo box in Access 2013. I don't want to populate the combo box with a SQL query. Instead I want to add my own values. How do I populate a combo box with a list of values that are not generated from a SQL query?

Answer: You might not always want to set up a code table to populate a combo box. There are cases when the values in the code box will never change. In this case, you might want to consider populating your combo box with a list of values that are "hard coded", so to speak.

To do this, open your form in design view. Right-click on the combo box object and select Properties from the popup menu.

Microsoft Access

Set the property called "Row Source Type" to "Value List".

Then in the "Row Source" property, list the values that you want to appear in the combo box. The values should be separated by semi-colons.

For example, you set the Row Source property to:

Satisfied;Not satisfied

In this example, there would be two values in the combo-box - Satisfied and Not satisfied. See below:

Microsoft Access