Autopopulate Subform with New Records
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!
|