Well. I have an order form(grandparent) that has a subform called "packing slip"(parent). Once I double click on a row of the packing slip subform, a seperate form called product form(child) will pop up. So, order has multiple packing slips, and packig slip has multiple products. I want to limit the total number of products (childeren) being added to be less than or equal to the number of product requested that is defined in a field in order form (grandparent). I know it sounds crazy!!!!!! My thought on that so far is to create a query that counts all the products in the entire packing slips related to an order, and somehow define a code that limits the product allocation to be less than or equal to the the number of product requested in the order form.