Although a criteria range often includes all fields from a table even those that are not needed to select records you have to include all field names from the table when setting up a criteria range.

Question

Quizplus · Accepted Answer

A criteria range only needs to include the fields relevant to the selection criteria, not all fields from the table.

Although a Criteria Range Often Includes All Fields from a Table