From the course: Microsoft Access: Forms and Reports

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Select data with a combo box

Select data with a combo box

From the course: Microsoft Access: Forms and Reports

Start my 1-month free trial Buy for my team

Select data with a combo box

“

- [Instructor] Our product review form can be used to add in new rows into the reviews table. The problem with it's current arrangement though is that these text boxes allow us to enter in values, but they don't really provide any context. Specifically, the review table only stores the product ID number for the product that's being reviewed. But, it would be a better experience for our end users if we could instead see the actual name of the product as we're entering in the data. To do this we'll convert this text box into a combo box or a list box instead. Let's take this form into design view. Then I'll select the existing product number text box and delete it. Next, we'll come up into the controls and on page number two we'll find either the control for the combo box, which is this icon, or the list box, which is this icon. The combo box and the list box are functionally identical. They'll both display a list of items that…

Contents