The easy way to do this is with a subform in continuous view, with the
list in a combo box on the subform. For an example, see the Orders form
in the Northwind sample database that's installed with every copy of
Access. The subform and the combobox where you select products are doing
just what you want.