Common Form Errors

The following pages will set up several mistakes that are common in database programming: bad spelling and incomplete punctuation. After the error has been tested, we will undo the mistakes and confirm that the Form or Query works again.

 

1. Try This: Create a Typo

Go to All Access Objects->Forms.

Open a Form in Design View: Movies.

Select a Control: Year.

Go to the Property Sheet->All.

Select the Control Source: Movie.

 

What Do You See? The Control Source drop down lists all of the Fields in the Record Source for this Form: tblMovies.

 

Keep going...

Form Design Tools ->Design->Tools->Property Sheet

Exam 77-885: Microsoft Access 2010

3. Building Forms

3.2. Apply Form Design options: View the Property Sheet