Multiple Lines Form

[DomSza]

Hi All,

I'm having an issue with creating a multiple lines form in a sub form. I have the basic layout set up correctly, which works fine. It's supposed to record each Product Code and quantity on a new line and the Customer Number, PO number and Delivery Date are repeated on each line.



Unfortunately, as you can see in the image below, only the Customer Number is duplicating correctly. The PO Number and Delivery date are not entered on each line. I didn't change any of the form field settings for the Customer Number, as they are identical to the other two fields, so I can't figure out why only this one is working.





This is what I was expecting to happen.



Thank you for your help,
Dom

[mbenton]

Are you using more than 1 table? If so try creating a query first, then build your form off the query.

[ranman256]

the sub form is prob linked on just 1 field. (which is all it needs)
but if you want more items in the subform, in design mode of master form,
click subform object
properties (data tab)
set the LINK MASTER FIELDS and CHILD FIELDS ...to all the fields in the master field you want duplicated

[DomSza]

Hi Ranman,

That's perfect! Thank you!

For anyone else who stumbles across this thread:

[NightWalker]

DomSza,

Thank you for posting your final step. It makes it easier to know if I am doing same thing correctly. Many times I follow a post then cannot get the last step without asking more questions. Again thank you.