graphic2
graphic1

Test the New Form Fields

Before You Begin: Change the View

Go to Form Design Tools ->Views->View.

Select a View: Form View.

 

Still Before You Begin: Find a Movie

Click on the Movie Field.

Go to Home->Find->Find.

Find What: Amityville II: The Possession.

Match: Any part of Find.

Click Find Next to go to that movie.

 

9. Try it: Test the New Form Fields

Check: Archived.

Change the Status: No Sale, Do Not reimage.

You can add some sample text to the Comments Field.

Please Close the Movies Form.

 

The data should be updated in tblMovies. You could find all of the movies that were released before 1990 and mark them as Archived.

 

Or...you can use an Action Query to update them all at once. Let's go for the Action Query.

Form Design Tools ->Views->View->Form View