I apologize if this has been answered as I searched through the threads and did not see this specific issue.
I have an input form for tracking personnel assigned to service calls. The input for the personnel is a drop down selection list. Right now I have 6 separate, but identical, fields to select up to 6 personnel. I though that would be enough but it is not. Plus it makes my form look cluttered with 6 selections when I only have 2 personnel to track for a service call, leaving me with 4 blank fields in my form.
Does Access 2010 have a function where I can create a button called "Add Personnel" so that I can have 2 personnel drop downs on the input form, but should I end up with 7 personnel, I can just click the button to add additional drop downs containing the same personnel data.
Thanks in advance for your insight!