Exam 77-424: Microsoft Access 2013
4.0 Create Forms
4.2 Set Form Controls: Delete Form Controls

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.

Please delete the Control and the Label for the Rating Field.

Keep going...