I have a form that holds a Stock Count Value in a sub form against a product name.  When I load the form I am populating the product names in the sub form but  I want to populate a field in the new form with the Stock Count Value from the last record created.  In other words, on load, I want to show the previous Stock Count Value for each product in my Sub Form.  Any ideas on how I can do this?

Thanks