A suggestion would be to build a simple query as the Row Source for the 2nd Combo Box filtered by what the user selects via the first Combo Box.
Query (Row Source) for 2nd Combo Box:
Criteria under CmtAreaCode field:
Like [Forms]![NameOfForm]![Combo13]
Combo13, in this example, is the name of the control for the 2nd Combo Box which is found in the Other Tab of the Property Sheet.
Row Source for 2nd Combo Box:
Example:
Code:
SELECT [NameOfYourQuery].[CommentsFieldName] FROM NameOfYourQuery ORDER BY [CommentsFieldName];
-RC