Open the Form in Design View

A Combo Box can look up data from one table and add it to another. This example will use a Combo Box to add the Rating from tblRating to tblMovies. Start by opening the Form.

 

3. Try it: Open the Form in Design View

Go to All Access Objects->Forms.

Select a Form: Movies

 

Go to Home->View->Views.

Select a View: Design View.

 

What Do You See? The Movie Form has a Control for Rating. It is a Text Box.

 

The goal of this programming is to delete the Text Box and replace it with a Combo Box so that the User can simply choose the answer from the list instead of typing it into the box.

 

Try This: Too: Delete Two Fields

Select the Rating Field and delete it.

Select the Genre Field and delete it as well.

Please delete the Control and the Label for both Fields. Keep going...