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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.