From the course: Access 2016: Forms and Reports

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Select data with a combo box

Select data with a combo box

From the course: Access 2016: Forms and Reports

Start my 1-month free trial

Select data with a combo box

“

- [Voiceover] When it comes to displaying data in your forms, there are three objects which you'll use most often. They're the text box, the combo box, and the list box. Because these three controls work with data, we'll have to connect our blank form to a data source if they'll work properly. I would like to connect this form to our feedback table, so let's take a quick look at it. Inside the feedback table, we have five records. The first column is the ID for the record, then it's followed by the product ID for the product that's being reviewed, the ID number of the customer that left the feedback, a column for the rating, a column denoting whether we can use this feedback publicly, as well as a column denoting the actual feedback that was left. Let's go ahead and close this down. I'd like to start a new form in design view by going to the create tab and choosing form design here. Now the first thing we need to do is connect this form to a data source and I can do that in the…

Contents