Access Populate table data in form and specify one of three key values

Murray Brown
Murray Brown used Ask the Experts™

I have the table shown below. I want the user to enter al values on a form and then I want to programmatically insert a key value in one of the last three columns. What id the best way to enter multiple lines? Should I use a sub form with the table or a list box. I would prefer the first option
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
What table?
Usually a subform is the best way to enter multiple items.
Murray Developer




Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial