Autopopulate Subform with New Records
This is what I am trying to achieve:
I have a form and form/subform with the following characterisitcs:
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.