Hiya folks!

This is what I am trying to achieve:

I have a form and form/subform with the following characterisitcs:

SALESFORM
SalesDate

SALESSUBFORM
Product
QuantitySold

PRODUCTDEFINITIONFORM
Product

Is it possible, so that when I create a new form... and as soon as I enter the date, the subform autopopulates with certain products select from the third table? Each time it will autopopulate with exactly the same products. This way all I have to do is to enter the quantity that was sold for each product.

Thank you!