Dear Adam and Scott,

Hi it's me again, thank you so much for the last time for shedding light on the double double quote issue when using DLookup, I watched those videos afterwards and I am fully understand what string concatenation is now!

So I presented the database prototype I created to my boss and he was impressed, except with additional request (as always).

This time he wants me to create a packing list form, which the name is totally not important in this context. Basically I have to create another form with subform, in which 90% of the info are exactly the same as the order invoice I created. What really bugs me is that because I already created an item list in the invoice subform (linked to OrderDetailsT) re that specific order ID. In the packing list form I really don't want to repeat the same tedious process again.

What I would like to achieve, if possible, is that in the packing list form once I select the same order ID as in the invoice form, the same list of items will be auto populated.

Appreciate if you guys can teach me how to make this happen, many thanks :)