I created a form for assigning incoming projects to employees. I have a main table that includes the majority of the data relevant to the project and I have another table with just the employee’s names, work unit, and an auto id field. The main table also has the employee’s name and work unit. I would like to set up the form (maybe a macro??) so that when a new entry is made the employee name is automatically selected sequentially from the table, and added to the form. Is this possible?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!