I have a form based on a query and specified Link Criteria. When the form opens it displays information based not only on the main query (Filter 1), but also on Link Criteria (Filter 2).

The count of the underlying recordset (created by Filter 1) equals 79 records but in this case the form displays only 3 records(due to Filter 2).

I need to loop through the 3 records displayed by Filter 2. In this case, Me.Count currently = 79. How do I add a filter to the actual underlying recordset (Me.Count) so that I weed out all the records except the 3 I want to loop through?

Any of this make sense?