Creating Top 10 in linked subform

I've created a customer database that contains customer info and sales
history. I have a customer form that on one of the tabs is supposed to show
the top 10 products purchased based on total revenue. This is a subform with
CustomerID fields linked. The underlying query in the subform contains
CustomerID, Partnumber, Description, Quantity (summed), and Revenue (summed
and ascending).

When I open the main form and go to the tab, my subform is blank.

The query works if I manually enter a filter for a particular CustomerID.
(It will show that customer's top 10 products). But when I try to run it form
the form, it doesn't.

Any suggestions?

Thanks,
Adam

Figured it out.

Put the following in the Criteria of my query for CustomerID:
[Forms]![frmCustomers]![idsCustomerID]


"Adam C." wrote:

I've created a customer database that contains customer info and sales
history. I have a customer form that on one of the tabs is supposed to show
the top 10 products purchased based on total revenue. This is a subform with
CustomerID fields linked. The underlying query in the subform contains
CustomerID, Partnumber, Description, Quantity (summed), and Revenue (summed
and ascending).

When I open the main form and go to the tab, my subform is blank.

The query works if I manually enter a filter for a particular CustomerID.
(It will show that customer's top 10 products). But when I try to run it form
the form, it doesn't.

Any suggestions?

Thanks,
Adam