Hi All,

I'm trying to fetch records but my usual method isn't working as I'm dealing with a subform now. My main form has 2 fields, part number and name.

I have a subform within the main form which has a lookup to both these fields. I would like the user to add a row to the subform and select a part number(s). I then need the subform name field to be auto populated with the corresponding name(s). The lookups in question are both multi-select.

Can anyone show me the correct syntax for this operation?