I need to design a form and a write a macro.

I have a drop down list with 10 items. Right now each of those items on the drop-down have to be selected one by one. Then that item will be entered into a table.

My goal is to create an addition item on the drop-down list which let me enter ALL items on the drop down list into the table associated with the drop-down list.

So the form/macro should be able to do the following: When choosing "Add all tests" from a drop down menu a macro should be triggered which will add all ten entries to an existing table.

Thanks for your ideas.

It is considered poor form around here to post the same question in more than one section. It wastes the time of people who might help you and clutters the place up with duplicate information. Thanks for paying attention to this in the future.

It is considered poor form around here to post the same question in more than one section. It wastes the time of people who might help you and clutters the place up with duplicate information. Thanks for paying attention to this in the future.


Thank you for you advice.