I have a form used to create purchase orders. In the parent form there is a field that is automatically generated as it is the ID field from a tblPO. I also have a drop down to select the customer, coming from a .
I have a subform that is used to write what material is being purchased for the specific customer. Is there a way for the Purchase Order number and the customer to auto populate into each record in the subform after selecting them is the parent form?? I am also trying to use a datasheet for the child form if that makes a difference.
Thanks in advance for your time.