While I am able to see the Product_Nbr Argument being passed into the Product_Edit form, I'm not able to have this second form display this particular record. It only displays the first record in the Product table.
How to I tell Access to re-read the product table based on the Product_Nbr being passed into it?
To rank something isn't that difficult. Basically, it is just to sort on the values to rank - points, goals, sales, citizens, whatever - in descending order or (typically for time) ascending order.
But how to rank dupes? Five methods exist, and they can all be implemented in pure SQL or using VBA.