Use the Expression
Builder
9.
Try it: Select an Expression Category
Go to the
Expression Elements.
Double
Click the database: FrontRowVideo Int4.accb.
Double
Click: Forms.
Double
Click: All Forms.
Select a
Form: MovieSearch.
What Do
You See? The Expression Categories list all of the Fields that
are available on the MovieSearch Form including the Popcorn Logo.
Try
This, Too: Select an Expression Category
Double
Click: RatingCombo.
Now,
What Do You See? The Expression Builder will write the qualified
name:
Forms![MovieSearch]![RatingCombo]
Where
Forms is the Access Object,
[MovieSearch]
is the name of the Form,
[RatingCombo] is the name of the Control.
Click
OK to close the Expression Builder and return to the
RatingSearchSQ Query.
Keep
going...