use query results in vb code

[minimal experience via AccessMonster.com]

I'm very frustrated. I have two tables, tblPoints and tblProducts.
tblPoints contains PointID (PK), CustomerID, ProductID, Date, and Invoice
Number. tblProducts contains ProductID, ProductName, and PointValue. At
the click of a button, I want to check to see how many points a Customer
has for each of the three products. If the Customer has >= 11 points for
any of the three products, I need to move the 11 purchases that the
customer made from the tblPoints and put them in an archive table. I can
check each product separately if needed.
I've tried numerous approaches and I can't come up with a solution. Any
assistance at all will be GREATLY appreciated. THANKS!

 

[minimal experience via AccessMonster.com]

Let it also be noted that I have the total amount of products purchased for
each product showing on a subform for each customer.